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 J_Tanna
What you would need to do, is to go into the Query Editor, and create a new connection to your SQL Server Table.
Then once that is created you would then go into the Advanced Editor and copy all the M Code.
Next you would then need to go to your Excel Source, and replace all the steps that refer to the Excel Source and then replace it with the copied code from the SQL Server table.
Hi GilbertQ
I need your help , I need more details about this step I have the same case for the posted question but you didn't show any details , could give some details on how to do this migration steps?