excel column that go on forever

[Anonymous]

hi all

I have a excel with worksheets that has column that go on forever

I understand I can use delete other column in power bi but it take a long time to load.

I have 10 such worksheet and more worksheet will be added and it will soon exceed powerbi limit of 16,000 columns.

How can I remove them in excel itself. I tried copy paste but there are too many formatting and formula.

I wonder if there is a way just to remove the blank column without touching any data?

Thank you.

[Icey · Accepted solution]

Hi @Anonymous ,

Please refer to the suggestions in this post: How to filter excel data during load to Power BI.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jimmy801]

Hello @Anonymous 

I don't get the point. An Excel can hold up to 16k columns in one worksheet, why are you afraid of reaching Power BIs limit? Why are you trying to eliminate Excel-columns by copy PASTING them? Do you have empty columns, that are read by power query or do you have data in Excel. In the first case just cancel empty columns - in the latter case remove them in power query before joining with other worksheets

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

@Anonymous ,

Please check https://support.microsoft.com/en-us/office/remove-columns-power-query-5c4b5906-84ea-467b-8a80-4edf2c4140cc if this helps.

Appreciate your kudos !! Mark my post as solution if fulfills your requirement.