Forum Discussion
Solved
Googlesheet CSV connection not importing properly
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 subse...
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.
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.