Forum Discussion
Power query limit columns?
Solved. It was an .xlsb, binary doc.
Hi SamWiseOwl
I'm loading the excel from a sharepoint folder, since there will be more files in the future.
I've made the data into a table in the excel file.
When loading in power query in the excel file from this table, I get all the columns.
When loading the same file in power bi, I only get about half of the colums. I didn't create any staps, except from the ones that are automatically created (see picture below)
Could you try with just a couple of rows as a test.
I recreated it with some dummy data and again it works fine
Well, I created a test fill and indeed, it works just fine.
But the file of the client doesn't work in power bi, but it does in excel. It always stops at the same column. I checked the file. There are no blanc colums, or hidden columns ....
Out of curiosity if you delete that specific column does it work?
Are there any privacy settings on the missing colums that are different from the initial 200?
Solved. It was an .xlsb, binary doc.