Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
------------------------------
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/
Hi @Anonymous ,
It has been confirmed that it is not possible to connect to the dataset in the service from SSIS.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do you know if this functionality available in future versions?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.