Power BI Dataset Data Source type change through API

[NMAN47]

We have a ton of Power BI reports that point to SSAS database as its source. Is there a way to change or update these data sources using Power BI API so that it now points to a Power BI dataset instead?

Thanks in advance,

NM

[V-lianl-msft · Accepted solution]

Hi @NMAN47 ,

Analysis Services and Power BI share the same meta data. By leveraging the XMLA endpoint of the dataset that is backed by a Premium capacity, you will be able to easily swap this connection.

For more details,please refer to:

https://data-marc.com/2021/09/29/swap-connection-from-analysis-services-to-power-bi-dataset/ 

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

[NMAN47]

Thanks for the reply. I will give it a try and see if it works.