Forum Discussion
Power Query selecting 9.000 columnsfrom Excel on OneDrive
Hello, I'm building a report where I need to access some data residing on an Excel OneDrive file, which has around 20-30 columns. I connect to this file using the Web Data Source. It connects fin...
If someone else lands here with the same issue, apparently after deleting the columns and clearing its contents, all you have to do to fix that is close the file and reopen it later. The scroll bar should be big, meaning that there are few columns to scroll.
If someone else lands here with the same issue, apparently after deleting the columns and clearing its contents, all you have to do to fix that is close the file and reopen it later. The scroll bar should be big, meaning that there are few columns to scroll.