Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am attempting to update my online dashboard. It feeds from 4 different excel files all in the same sharepoint folder.
If I go in to the desktop version, click refresh data, save and upload then the refresh is fine. However, when I attempt to update the data from PowerBI online I recieve the below error:
Last refresh failed: Thu May 20 2021 16:22:01 GMT+0100 (British Summer Time)
There was an error when processing the data in the dataset.Hide details
Processing error: | The key didn't match any rows in the table. |
Cluster URI: | WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net |
Activity ID: | 0f3c64d5-e76d-435b-9e9f-aad94b5f9624 |
Request ID: | dba74d13-2ec0-30c2-86c5-18b21e9a7276 |
Time: | 2021-05-20 15:22:01Z Any help would be appreciated. I have already tried a solution that suggested ensuring all the sheets have the same name. |
Hi @Anonymous
This issue seems to happen if the key word doesn't match between dataset and data source.
Please check whether you have changed the sheet name in Sharepoint folder.
From your statement, you can refresh your report successfully in PBI Desktop. Republish your report, configure your credential and try to refresh your dataset again. Please check the result.
I find some same issue like yours and I hope they could help you.
Post1:Expression.Error: The key did not match any rows in the table
Post2:Expression Error.: The key didn't match any rows in the table
From Post2 I get some advice:
In order to avoid the error ralated to the sheet name chnaging unexpectedly, i use the { recordnumber} notation instead , to access the Binary of the Excel File and later the Sheet. Here i access the first file ie {0} of my Sharepoint folder , then get its content and then take its first {0} sheet
#"_FileContent" = try #"Filtered Rows"{0}[Content] otherwise error "Pas possible d'accéder aux données du fichier: " & _FileName,
#"Imported Excel" = Excel.Workbook(#"_FileContent"),
Feuil1_Sheet = #"Imported Excel"{0}[Data]
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.