How connect ssis with a dataset premium to process with script xmla

[Cobra77]

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

[Anonymous]

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

[v-deddai1-msft · Accepted 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