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.
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.