Forum Discussion
Solution SageData source change
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
Super UserHi Sujit_Thakur
If it's the same data then create a new query and import the data from SQL Server. Create steps to get the data into the same structure/format as it was when you were using it as a source from Excel/Sharepoint.
Then copy/paste the steps from the old query into your new query from the point at which the data is the same in both queries.
You may need to manually change a step name from your old query to match the last step in the new query.
This is easeir to explain with actual code!
Phil