The Key doesn't match any rows in Google Big Query table

[rafael6bds_]

Key doesn't match any rows in Google Big Query table. My error still persists, I'm using a source as import in Google Big Query, I even separated each table into a pbix file to update, but the error happens in all files, no know what to do.

[rafael6bds_]

hello @v-yalanwu-msft use authentication method oauth2, privacy level : public, my user has read and write permissions within the project in Big Query, the error only happens in Power bi Service in updates made by schedule, in power bi desktop they do not occur, table updates occur every hour in the 00 minute, taking 10 minutes on average to complete scheduled power bi updates in the 30th minute of every hour 8 times daily.

[v-yalanwu-msft]

Hi, @rafael6bds_ ;

Please make sure the account you're using has at least read permissions, otherwise this error will be thrown. or try to resolve the issue through the following:

1. Select Edit Queries from the menu to open the Query Editor
2. Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
3. On the applied steps menu at the right select the source step.
4. In the top menu bar, select Refresh Preview.

https://systemmanagement.ro/2018/05/18/power-bi-the-key-didnt-match-any-rows-in-the-table/

https://docs.microsoft.com/en-us/power-query/connectors/googlebigquery

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.