Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 powerb...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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