Can't 'See' Google Sheets Worksheet Name

[Anonymous]

Hi all,

I have a dashboard that is pulling data via Google Sheets. On trying to refresh it this morning it returns an error of 'The key didn't match any rows in the table'. On further investigation, it looks like that when PowerBI is looking at the Google Sheets export (done via 'Publish to Web') the sheetname is being lost and is instead coming through simply as Sheet10 hence it can't connect to the sheet that it formerly knew as 'Campaigns Data'.

Has anyone else experienced this? I'm not sure if it's a PowerBI or a Google Sheets problem, but any advice most welcome!

Thanks,

Sam

[v-danhe-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[Anonymous]

Hi Daniel,

The solutions presented above don't really help unfortunately as I am still intermittently getting the error.

Thanks anyhow,

Sam

[v-danhe-msft]

Hi @Anonymous ,

Based on my test, it seemed work on my side:

Could you have tried with below link to get data form Google Sheet:

https://bizone.co.th/2016/09/26/connecting-power-bi-to-google-sheets/

And you could check if you have changed any data for your Google Sheet:

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/td-p/186522

Regards,

Daniel He