Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
How connect ssis with a dataset premium to process with script xmla ? the best practice ?
From SSMS , i can connect to powerbi://api.powerbi.com/v1.0/myorg .... and process a partition
But in VS 2019 , SSIS , with a connexion manager , if i try to connect the datset as a tabular ssas cube i have the message :
"Errors in the OLE DB provider. Failed to load managed ADAL component."
Repair VS 2019 , repair SSIS, repair SSMS, re install ssas project ... the same.
And idea ?
Or the good provider used ?
Thanks for your help.
Best regards
Solved! Go to Solution.
Hi @Cobra77 ,
It is not possible to connect to the datasets from SSIS. Here is the similiar post for your reference : https://community.powerbi.com/t5/Service/connect-to-powerbi-dataset-in-service-from-ssis/m-p/1160988
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Cobra77 ,
I hade the same problem and I got rid of it by re-installing the latest version of the Microsoft OLEDB PRovider for Analysis Services (15.0) https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions
Hope this solves your problem as well,
Marisol
Hi @Cobra77 ,
It is not possible to connect to the datasets from SSIS. Here is the similiar post for your reference : https://community.powerbi.com/t5/Service/connect-to-powerbi-dataset-in-service-from-ssis/m-p/1160988
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai