Forum Discussion
PowerBI web app automatic Google Analytics refresh error: The key didn't match any rows in the table
Hi PBI'ers,
I made a dashboard with Google Analytics data, it refreshes automatically overnight through the PowerBI web app.
It worked for like 2 months, unfortunately I sometimes get the following error:
"The key didn't match any rows in the table: [table]"
Then the refresh has failed, does someone have any idea why and how to fix this?
(I load 2 years of data in a dynamic way from Google Analytics)
Thanks already,
kind regards,
MrNelsch
Anonymous,
This may caused by some steps in power query(advanced editor) don't match the previous steps. You can click query editor-> advanced editor to check them. Similar case: https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824/page/2.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Anonymous,
This may caused by some steps in power query(advanced editor) don't match the previous steps. You can click query editor-> advanced editor to check them. Similar case: https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-any-rows-in-the-table/td-p/9824/page/2.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.