Can't 'See' Google Sheets Worksheet Name

Question

Hi all,&nbsp;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'.&nbsp;Has anyone else experienced this? I'm not sure if it's a PowerBI or a Google Sheets problem, but any advice most welcome!&nbsp;Thanks,&nbsp;Sam

v-danhe-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
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
&nbsp;
Regards,
Daniel He

v-danhe-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
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?
&nbsp;
Regards,
Daniel He

anonymous · Answer

Hi Daniel,&nbsp;The solutions presented above don't really help unfortunately as I am still intermittently getting the error.&nbsp;Thanks anyhow,&nbsp;Sam

Forum Discussion

Can't 'See' Google Sheets Worksheet Name

3 Replies

Related content

Google sheets

Error connecting to Google Sheets

Cannot connect to google accounts through google sheets connector

Google Sheets

Combine multiple Google Sheets from Google Drive