Googlesheet CSV connection not importing properly

[msgrewal]

I had this posted as 'Column not found' issue earlier, but now I have realized that issue is with CSV import from googlesheets. Since the csv is not importing properly, columns are not found in subsequent steps.

- This issue started overnight on Dashboard refresh.

- All 5 googlesheet connections in my dashboard have same issue. Other connections working fine.

- All connections (including google sheet csv connections) have been working fine for 4 months until yesterday.

- No underlying data, data structure, csv link from google sheets has changed.

My source is showing this for a google sheet CSV import:  

Normally it shows like this (regular CSV import) :

Screenshot truncated on right due to data privacy.

All standrad googlesheeet csv connection import steps have been followed.

As mentioned, all has been working fine for 4 months.

[msgrewal · Accepted solution]

Alright. Found the fix. 

Somehow shared setting on google drive files changed.

I changed them (only for sheets I need) to 'Anyone with link' can view.

That fixed the problem, and now Power query is loading everything, including columns etc fine.

[edhans]

@msgrewal - not sure why you started a new thread. I don't think this is a source (Power BI) issue. I don't think that is a CSV file. Open the file in NotePad. Does have columns and commas seperating them, or does it have that JSON code in your screenshot?

It is possible Google changed the export format, or the format type is wrong. I know when I download files from Amazon I have multiple options. Same data, but different formats. Ensure your format choice is the same as last months.