I have created a simple package that uses a Power Query connector and loads into a sql server table. I have developed this in Visual Studio 2019 and installed the required Power Query Connector (I am developing in VS on the server I am also deploying to).
I can execute the package in Visual Studio successfully, however when I deploy it to SSIS server and execute from a job step I get an error on the package:
Package: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.