Changing datasource from SharePoint list to SQL

[Matthias93]

Hi,

I currently have a dashboard that is getting data from a dozen SharePoint lists. There's a possibility our solution is being migrated to SQL. I was wondering if there's a way of changing the data source of my queries from SharePoint to SQL without losing the query steps and realtionships. I'm connecting through the standard SharePoint list connector of PowerBI.

Kind regards,

Matt

[Anonymous]

Hi @Matthias93,

If you refer to the APPLIED STPS in Query Editor as shown in the first screenshot, open Advanced Editor of your SharePoint list query in Power BI Desktop, copy the codes and paste codes in Notepad.



Then change the source in the codes to SQL Server database, you may also need to change column names or other objects in the query steps. After you change the codes based on SQL Server database, add a new blank query in Query Editor and paste the codes in the Advanced Editor of the new query.

In addition, when you load data of different tables to Power BI Desktop, Power BI Desktop will attempt to find and create relationships for you. If Power BI Desktop cannot determine with a high-level of confidence there is a match between tables, it will not automatically create the relationship. You can still use the Manage Relationships dialog to create or edit relationships.


 
Thanks,
Lydia Zhang