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.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)