Forum Discussion

christianfcbmx's avatar
christianfcbmx
Post Patron
7 years ago
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...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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