topic Re: Power BI Dataset Data Source type change through API in Developer

Power BI Dataset Data Source type change through API

NMAN47 — Wed, 09 Mar 2022 23:19:21 GMT

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,

Re: Power BI Dataset Data Source type change through API

V-lianl-msft — Mon, 14 Mar 2022 02:40:46 GMT

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.

Re: Power BI Dataset Data Source type change through API

NMAN47 — Tue, 15 Mar 2022 15:48:16 GMT

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