How can I change source from EXCEL FILE TO SQL?

[christianfcbmx]

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

[Anonymous]

This is good. how do you do it when the data from sql is from mutiple tables?

[v-danhe-msft · Accepted solution]

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