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 is there a tutorial ro something where to watch?,,,Im trying to do this and I cant.
Thanks in advance.
- Hi there
I do not know of anything off the top of my head, but that is a good idea for a blog post. This blog post should assist you Changing Data Source Location in Power Query • My Online Training Hub