Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DATA REFRESH

Hello guys,

 

I can't refresh my data which come from EXCEL documents.

I don't have any error message, for POWER BI refresh is ok mais but nothing happen.

I have 2 source of DATA /

SQL SERVER and Excel document

Refresh is ok with SQL server but not with EXCEL Document.

I select again data in power query editor but still nothing change.

 

Any ideas ? thanks.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Can check under edit data source setting and check excel location is correct

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Anonymous 

     

    A Excel file contains a lot of sheets or tables. Even though your data structure isn't changed, the name of table is different. Power BI won't find the source table. Please make sure the sheet names or table names are consistent.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.