Data refresh using Excel

[SachinC]

Hi,

I created a PowerBI report using an Excel file, i.e. Get Data>Excel.

I've created my reports and everything is great.

However, i have a newer Excel file with latest data - how do I get my PowerBI charts to reflect the new Excel file?

I used the Edit Query>Data Source Settings method, however I get an error: Expression: Error: The key didn't match any rows in the table.

How do i sort this please?
Thanks.

[v-jiascu-msft · Accepted solution]

Hi @SachinC,

A Excel file has many sheets or tables. Though your data structure isn't changed (I guess so), the table name is different. Power BI can't find the source table. Please change the name of the tables in Excel.

Best Regards!

Dale

[v-jiascu-msft · Accepted solution]

Hi @SachinC,

A Excel file has many sheets or tables. Though your data structure isn't changed (I guess so), the table name is different. Power BI can't find the source table. Please change the name of the tables in Excel.

Best Regards!

Dale

[v-jiascu-msft · Accepted solution]

Hi @SachinC,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale