Forum Discussion
Sujit_Thakur
Solution Sage
Solution SageData source change
Dear All , I have made some reports , which were made from Excel files imported from SharePoint . But now challenge is that data is being shifted to data base and now to be querried using SQL se...
Sujit_Thakur , Create a new connection using SQL server. Open Edit query and right on table and open advance editor and get the script and use this script in place source in old pbix.
Keep backup of file
refer: https://community.powerbi.com/t5/Desktop/Change-Sql-Connection/td-p/11502
amitchandak
Super User
Super UserSujit_Thakur , Create a new connection using SQL server. Open Edit query and right on table and open advance editor and get the script and use this script in place source in old pbix.
Keep backup of file
refer: https://community.powerbi.com/t5/Desktop/Change-Sql-Connection/td-p/11502