Forum Discussion

SteveS1's avatar
SteveS1
New Member
10 years ago
Solved

Expression.Error: The key didn't match any rows in the table

I need assistance.   I get the above shown expression error. I am in the desktop.  I  am connecting to an Azure SQL database.  It has 20 tables. I have previously direct connected to 18 of the 20....
  • pqian's avatar
    pqian
    10 years ago
    You are seeing locally cached results been returned. I think the 19th table is new in the database and therefore doesn't exist in the local cache. In this case simply refresh from the navigator (button right on top of the error) should work.

    In the next release of desktop we plan to automatically refresh your local cache if we see this error.
DevinHarrington's avatar
DevinHarrington
Regular Visitor
10 years ago

I am still getting this error after the latest PowerBI update / clean push to web.

 

Have stepped thru all the .xlsx and solutions I've found online w/ no luck.

 

Does anyone know if PowerBI has a logging component so I could try to find the step this error occurs for me?  Hard to track down since the error doesn't occur on my desktop ever, only scheduled refresh from personal gateway.

AndrewDang's avatar
AndrewDang
Icon for Helper IV rankHelper IV
9 years ago

I have this issue when I try to load 43 similar excel files from one folder into Power BI. I am wondering if there is any tips to help with this?

 

THanks;

Andrew