cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamBerger Regular Visitor
Regular Visitor

Can't 'See' Google Sheets Worksheet Name

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

3 REPLIES 3
Community Support Team
Community Support Team

Re: Can't 'See' Google Sheets Worksheet Name

Hi @SamBerger ,

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

1.PNG

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...

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Can't 'See' Google Sheets Worksheet Name

Hi @SamBerger ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SamBerger Regular Visitor
Regular Visitor

Re: Can't 'See' Google Sheets Worksheet Name

Hi Daniel,

 

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

 

Thanks anyhow,

 

Sam