How to Replace Data Source in Power BI Service

[sivaadityat]

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!

[NandanHegde · Accepted solution]

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