Forum Discussion
Solved
How can I change source from EXCEL FILE TO SQL?
Hello Community,
I have 7 excel tables in a pbix model and now the tables were moved to SQL (same structure)... I need help to change the source to SQL and make the report to work again.
Aney body could guide me pleease...I heard abt the advance editor but I still dont get the idea.
This is my escenary with the query editor...
Any help would be so much appreciate it.
excel M codeSQL M code
Hi christianfcbmx ,
You could just copy all the code in the SQL advanced editor to replace the code in the excel advanced editor, it could work on my side.
Regards,
Daniel He
2 Replies
Hi christianfcbmx ,
You could just copy all the code in the SQL advanced editor to replace the code in the excel advanced editor, it could work on my side.
Regards,
Daniel He
