Forum Discussion
Powerr BI data refresh
Hi,
I have created a very simple report in PowerBI desktop on my laptop and connected it to an Azure SQL database.
All works fine in powerbi desktop, however when I deploy the dataset to powerbi.com I get the following error when I refresh the data.
Hi Anonymous ,
Is there any changes on your data table structure? It seems like cached query table structure not match with updated new data structure.
You can enter to query editor and 'change type' steps to manually fix unmatched or missed table key fields.
Expression Error.: The key didn't match any rows in the table
Regards,
Xiaoxin Sheng
1 Reply
Hi Anonymous ,
Is there any changes on your data table structure? It seems like cached query table structure not match with updated new data structure.
You can enter to query editor and 'change type' steps to manually fix unmatched or missed table key fields.
Expression Error.: The key didn't match any rows in the table
Regards,
Xiaoxin Sheng