Forum Discussion
How to Replace Data Source in Power BI Service
Hello all,
I got a requirement in Power BI that, I need to replace data source in published dashboard without downloading it to desktop. Is it possible? I am using SQL , SAP tables as my datasource.
Also, I read this is not possible in service & we need to download and change the data source in Desktop end. Please suggest me, is there any workaround for this issue?
Any inputs / suggestions are highly appriciated.
Thank you!
you can parameterize the data sources in power bi:
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
to update the data sources.
you can even use REST API :
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources
1 Reply
- NandanHegde
Super User
you can parameterize the data sources in power bi:
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
to update the data sources.
you can even use REST API :
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources