Connect to power bi dataset in SSIS

[Anonymous]

Hi,

I am trying to find out the steps to connect to powerbi dataset. I would like to get the metadata of the dataset in Power BI Service using MDX/DAX. It is working fine in SSMS but I'm getting error in SSIS connection string. Can you please let me know how to resolve this issue?

Error:

TITLE: Connection Manager
------------------------------

Test connection failed because of an error in initializing provider. Azure Analysis Server returned the following error: Unauthorized

Technical Details:
RootActivityId: 6ade9359-ffc3-481f-ad0e-994e4b922a70
Date (UTC): 8/3/2020 11:28:29 PM
The response returned from the HTTP server is not valid.
The response returned from the HTTP server is not valid.

------------------------------
BUTTONS:

OK
------------------------------

[tomasbaima_ok]

For PRO License you can try something like this, the same connector exists in SSIS: 

https://freesbi.wordpress.com/2022/01/11/conexion-en-modo-import-a-un-dataset-de-power-bi-publicado/

[V-lianl-msft]

Hi @Anonymous ,

It has been confirmed that it is not possible to connect to the dataset in the service from SSIS.

https://community.powerbi.com/t5/Service/connect-to-powerbi-dataset-in-service-from-ssis/td-p/1160988 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Do you know if this functionality available in future versions?

[V-lianl-msft]

Hi @Anonymous ,

I don't know for the time being when this plan will come into being

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

I actually have a blog post on how to do this here: https://www.fourmoo.com/2020/08/12/how-to-use-ssis-with-power-query-to-extract-data-from-power-bi-pr...