Error connecting to Google Sheets

[PM_Insights]

Hi All, 

I am trying to connect my Power BI to Google Sheets that is provided by my client. This is supposed to be a live data-sheet that will get refreshed on a daily basis. While trying to connect the data-sheet, I received the following error. What does this mean? Please help!

DataSource.Error: Unable to parse range: Connected Sheet 1!A1:GI500
Details:
errorstatus=INVALID_ARGUMENT
errormessage=Unable to parse range: Connected Sheet 1!A1:GI500
errorcode=400

Thanks,

PM

[PM_Insights]

Thanks for responding @Greg_Deckler . This Google Sheet contains nested dataset. Is that the reason this might be happening? Would you know? How do I un-nest this nested dataset, using Power BI? 

[Greg_Deckler]

@PM_Insights Any chance you can share an example of the nested data as a Google sheet? Then I could do some troubleshooting.

[Greg_Deckler]

@PM_Insights Maybe this helps? Troubleshoot API errors  |  Google Sheets  |  Google for Developers