Forum Discussion
Solved
Data 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
Dear all ,
Thanks for answering so promptly .
I will surely try what amitchandak sir have advised from a shared post.
it could take a week to mark answer to this question , please bare with me !
thank you friends .
Others can also suggest and share if they have some idea