Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Saludos expertos,
En la organización tenemos configurado un excel por cada área que contiene información de sus indicadores. Cada área puede tener hasta 10 indicadores diferentes, queriendo decir que en su archivo de excel puede tener hasta 10 hojas para cada uno de los indicadores (10 hojas = a 10 Tablas).
Si en la organización tenemos alrededor de 12 áreas. Cada área con aproximadamente 10 indicadores, esto sería al rededor de 120 tablas.
El problema radica cuando importo las 100 tablas, las consultas se vuelven lentas y el rendimento de power bi consume toda la maquina. Termina por bloquearse y no responde.
NOTA: Cada excel debe estar independiente para cada área . Si lo consolidaramos todos los excel sería poner una persona en esta tarea para luego pasarselo a PBI consolidado, y no sería eficiente este procedimiento por los cambios y actualizaciones en la informacion.
Alguna sugerencia para mejorar el rendimiento? Una forma de consolidar, importar que no consuma toda la maquina?
Gracias!
Solved! Go to Solution.
Hi @aijou1984 ,
You could reduce the size of your excel files, please refer to
https://docs.microsoft.com/en-us/power-bi/connect-data/reduce-the-size-of-an-excel-workbook
Or, you could import your excel files to SQL server, then get data from SQL server in Power BI Desktop with Direct Query connection mode.
This is an article about optimization, please refer to
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aijou1984 ,
You could reduce the size of your excel files, please refer to
https://docs.microsoft.com/en-us/power-bi/connect-data/reduce-the-size-of-an-excel-workbook
Or, you could import your excel files to SQL server, then get data from SQL server in Power BI Desktop with Direct Query connection mode.
This is an article about optimization, please refer to
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Don't use Excel as a data source. See if you can convert to a CSV based data source. It won't be lightning fast, but definitely better than Excel.
How many columns in each file? Do you really really need all the columns?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |