Click here to Skip to main content
15,946,988 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I trying to load data from power bi dataset to SQL server table. I created one SSIS package which is running fine in my local machine. After deployment into the server and running in SQL server agent job it is not running and throw the below error. I have installed power query source plugin in local and server machine.

Data Flow Task:Error: The data protection operation was unsuccessful. This may have been caused by not having the user profile loaded for the current thread's user context, which may be the case when the thread is impersonating.

What I have tried:

I tried using service account to run job. Still it is not working

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900