Forum Discussion
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 OthersHi LauraPS ,
16.000 columns is the maximum allowed in a Power BI semantic model has you can see in the limitations and considerations
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.
LauraPS
Hola Laura.
Te sugiero revisar si realmente necesitas una tabla con tantas columnas.
NO es recomendable usar tablas con tantas columnas para el manejo de datos, es preferible generar tablas con pocas columnas y muchas filas. Una opción es generar la misma tabla pero transpuesta.
Por otra parte, por favor precisar qué quieres decir con "actualizar excel en powerbi"; no es claro a qué te refieres: se puede entender por ejemplo que tienes un archivo de power bi con una consulta o varias consultas relacionadas con un archivo o varios archivos de excel cuyo etl realizas con power query. Otra posible situación es que ya tengas un modelo en power bi y exportes una tabla a excel y supera la capacidad disponible.