NEED HELP columnas

LauraPS 

Hi i am wrting in English, you need to clean the source file in Power Query, remove unecessay columns and some times excel treat ghost data and treat them as column and in reality that is not correct.
Check excel file it should not have any empty tables in there.

If this helps, ✓ Mark as Kudos | Help Others

Hi LauraPS ,

16.000 columns is the maximum allowed in a Power BI semantic model has you can see in the limitations and considerations

https://learn.microsoft.com/en-us/power-bi/connect-data/service-get-data#considerations-and-limitations

My question is do you need a semantic model with 16.000 columns? has refered by other super users you must clean up your model and understand what is used or not in your report and your semantic model one good option is to use the Measure Killer that alllows to check your full semantic model and your reports for unused columns, and measures.

https://www.brunner.bi/measurekiller

I always go by the quote just use what you need sometimes people tend to add everything to their models because they will need it in the future and from my experience most of the time you don't need everything.

Go to the Excel file

Select the column after your data (empty column)

press ctrl+right

right click on one of them and select delete column.