Forum Discussion
How to change data source from EXCEL to SQL Server?
Hi GilbertQ
I am facing same problem. But not able to understand what you want to convey. Would you like to convey it in more detail? That could be a big elp for me.
Thank You.
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.
- christianfcbmx7 years agoPost Patron
hI GilbertQ is there a tutorial ro something where to watch?,,,Im trying to do this and I cant.
Thanks in advance.
- GilbertQ7 years agoSuper UserHi there
I do not know of anything off the top of my head, but that is a good idea for a blog post. - GilbertQ5 years agoSuper User
This blog post should assist you Changing Data Source Location in Power Query • My Online Training Hub
- MAAbdullah_475 years agoHelper V
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?