Forum Discussion
Download a dataset using SSIS
Do you have the latest versions of the client libraries:
https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions
worth installing x86 as well as x64 if it will let you. SSIS running locally often gets hung up on needing 32 bit libraries.
Thank you bcdobbs for replying.
I dont see any new providers after installing the client libraries. I might have the latest one already installed then.
Please let me know if you came accross this scenario of connecting to Power BI Datasets from SSIS?
I am able to connect using SSMS.
I am also able to connect Power BI Desktop underlying tables from SSIS, however not from the Power BI Service datasets.
No direct experience I'm afraid but will certainly try once I get into work. (About an hour)
Suggestion was from prior experience fighting with SSIS on other things.
Possibly unrelated but my work still uses excel 2016 which even with latest libraries hangs when I try and connect to xlma end point via the wizard. Was able to work around that by building a connection file in a more modern version of excel and using that. Will get back to you later this morning.
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 CommunityLooks 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