Changing Power BI Data source

[SwapnilMahajan1]

Hello everyone,

During an interview, I encountered this question and I'm looking for an answer to it. Despite conducting a Google search, I haven't been able to find a response that fully satisfies my query.

The question is:

Imagine we've created 150 dashboards using an on-premises data source. Now, the company has shifted to a cloud-based database and wants to transition all 150 reports to use the cloud-based data source automatically. They wish to avoid the manual process of opening each report to update the data source. Is there a method to automate this process?

[vanessafvg]

i guess because you are asking this retrospectively its after the fact but  if you parameterize your connections from the get go, so not post the fact then changing  the environment variable should allow you to do this,  (in theory, of course theory isn't always that simple, specially cos on prem to cloud which may have differences)

the other way you could possibly also do it is via the xmla point (which you can only use if you have premium)

although I am not sure how you would loop through each connection.  but changing it in tabular editor would be easier.  

https://powerbi.microsoft.com/cs-cz/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-d...

i think what they probably referring to is using the Rest API and doing it via the api

https://learn.microsoft.com/en-gb/rest/api/power-bi/gateways/update-datasource

[Idrissshatila]

Hello @SwapnilMahajan1 ,

It should be changes manually in every power bi report so it would read from the new source, because this should be done in power bi desktop.

unless, all the reports are reading from a power bi dataset that is published to service, then its enough to change this one only and the change will reflect to other reports reading from it.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡