Forum Discussion

christianfcbmx's avatar
christianfcbmx
Icon for Post Patron rankPost 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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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