Forum Discussion
Download a dataset using SSIS
Hello, Getting the below error from SSIS while trying to connect to the dataset, from the same machine I can connect o the dataset using the Power BI desktop App, and using DaxStduio. Also ...
No afraid I can't make it work either even playing directly with the connection string.
I think this might give you a way forward:
Solved: How Can I Connect to Premium Model via XMLA Endpoi... - Microsoft Power BI Community
Looks like issue is SSIS can't authenticate on O365 (might be wrong on that) so you need to use a service principal. Setup as follows:
Embed Power BI content in an embedded analytics application with service principal and an application secret - Power BI | Microsoft Docs