Forum Discussion
Report suddenly stopped refreshing in Power BI Web
My report suddenly stopped refreshing in Power BI Web. After that, I tried to refresh it in Power BI Desktop and discovered that one of the tables had duplicate rows, which caused relationship errors between tables. I removed the duplicate rows, and after that, the report refreshed successfully in Desktop. However, when I uploaded it to the Web, it still doesn't refresh—neither manually nor on schedule. The error is as follows:
Data source error: Expression.Error: The key didn't match any rows in the table. Microsoft.Data.Mashup.ErrorCode = 10061. Key = [Name = "map-hotels"]. Table = #table({"Name", "Description", "Data", "Kind", "DisplayName"}, {}). ;The key didn't match any rows in the table. The exception was raised by the IDbCommand interface. Table: Incoming Calls B2C.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: b54951fb-3e4c-4ff3-a491-d0525542c7a6
Request ID: cf69e25a-4831-4f51-b11a-6e8e42dd8ec2
Time: 2025-04-07 05:18:20Z
Moreover, each time I attempt a refresh, the error appears with different tables.
I’m using Google BigQuery (multiple tables), Google Sheets, and Web (CSV files) as data sources.
Could you please advise how to make the report refresh successfully in Power BI Web?
Hello Igor_Ukraine ,
this issue Expression.Error: The key didn't match any rows in the table. , means that there's is some sort of permission / access issue between the user that the dataset configured with and the source.
3 Replies
- Idrissshatila
Super User
Hello Igor_Ukraine ,
this issue Expression.Error: The key didn't match any rows in the table. , means that there's is some sort of permission / access issue between the user that the dataset configured with and the source.
I just updated the BigQuery credentials in Power BI web, and the refresh started working. Thanks for pointing me in the right direction.
v-hashadapuCommunity Support
Hi Igor_Ukraine , Thank you for reaching out to the Microsoft Community Forum.
The "Expression.Error: The key didn’t match any rows in the table" in Power BI Service means it can’t find tables like "map-hotels" or "Incoming Calls B2C" during refresh, likely due to outdated credentials or source changes. In Power BI Service, update Data source credentials for Google BigQuery, Sheets, and Web CSV using OAuth2. In Desktop, clear cache (File -> Options -> Data Load) and permissions (Transform Data -> Data Source Settings), reconnect sources, test a refresh, and republish. Check that all tables/files still exist and match their original names, then test manual and scheduled refreshes in the Service.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
