Unable to get data from google sheet

Question

Not sure if this was resolve, but i cant get data from google sheets. Instruction seems pretty straight forward but somehow can't connect from my power bi desktop or dataflow.&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;- are you still having trouble?&nbsp; If could you share more detail about the error message that you are encountering.&nbsp;You may want to try connecting to this example Google Sheet to show get screenshots to show us the error that you encountering:https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

anonymous · Answer

Hello i was able to get data from the google sheets you sent to me somehow this particularly google sheet i cant get the data...

https://docs.google.com/spreadsheets/d/1i0AuPyNOoI77CbAWieY8-M1amvfAHkcc/edit#gid=205813798

anonymous · Answer

Anonymous&nbsp;- odd, you might need to rebuild the google sheet to see if there is particular component that causing the issue.&nbsp; Is it possible that the Google Sheet has password. This would normally stop a Excel file from working in Power BI.

anonymous · Answer

Hello, yeah it was odd i cant get data from this particular google sheet. Unfortunately, i did create the google sheet it was only shared to me also. i believe it has no password since we were able to view the data&nbsp;

Forum Discussion

Unable to get data from google sheet

4 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