Forum Discussion
How to change data source from EXCEL to SQL Server?
Hello All, Currently i have loaded all the files from my local disk to powerbi and those are all EXCEL sheets. then i have imported those excel sheets to SQL SERVER. Now i would like to chan...
Hi Anonymous
First thing is to make a copy and work on the existing copy of the PBIX file so that you have a backup.
What I have done in the past is to import your data as you would from the SQL Server Tables into a table in the Query Editor.
The next steps involve using the Advanced Editor in the Query Editor, and what you would do is to copy all the steps from the SQL Server Tables query where it gives you all the column names.
Then take this and replace it in your Excel Source tables. It can be a little tricky but that will work, I have done it quite a few times in the past.