Scenario
In this blog, we can see how to change the SharePoint on-Premises data source to SharePoint Online of a Live Power Bi Dashboard. A few days back when an internal SharePoint migration occurs within my organization then we face some major challenges in Power BI Dashboard. My purpose is how to overcome these challenges we can see in this blog step by step
When SharePoint migration occurs first thing that happens is failure of Schedule refresh of Dashboard,
Data showing in the dashboard, is not up to date, due to a change in the broken SharePoint URL which is used in the report.
Step 1
Open .pbix file in Power BI Desktop
Go to -> Transform Data -> Power Query editor mode -> Select Query
Step 2
Applied steps - Select Source Gear icon
Replace the existing URL with migrated SharePoint Online URL & click OK.
This will take a few minutes to refresh the power query. If your data source is large then it will take more than 5 minutes.
Step 3
You can see the Navigation steps throwing an error
[Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Id=b1348c45-3c47-49fe-918b-9b2bfe449968]
Table=[Table]
The error states that the existing list GUID is not matching with updated SharePoint data source
To overcome this bizarre error do the next step carefully
Step 4
Go to the Last step -> Source -> Select table in query
Identify the table used in the old data source, select the same table in the new data source & copy its id which is an alphanumeric key
Step 5
Go to Navigation step just replace copied ID with the = Source {[ID = “ABA213423-addsasd”]}[Items]
Finish
Power query refresh the data source if you did the above steps carefully then surely you will not face any error, hence Refresh all the queries SAVE & Publish the dashboard.
Conclusion
This is how we can change the Live Power BI dashboards to migrated SharePoint data source, schedule refresh will work as it is if there is not any change required if you selected the Organization account in Data source settings.