We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi All,
New to this group, so thank you for the help in advance. I am currently facing a problem with refreshing the dashboard. I am using Excel files from a shared drive as input. Each Excel file is around 20MB in size, but when refreshing, it is displaying in GBs and not completing the refresh even after a day.
Solved! Go to Solution.
Hi @Vasudevan606,
The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.
Improving Power Query Calculation Performance With List.Buffer()
Optimising The Performance Of Power Query Merges In Power BI
I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi @Vasudevan606,
The source file size does not mean the refresh operation only processed with these data, if you query table include complex operations(e.g. merge, combine, reference across query tables , invoke custom functions...), they may also affect the resource that spend on refresh.
Improving Power Query Calculation Performance With List.Buffer()
Optimising The Performance Of Power Query Merges In Power BI
I'd like to suggest you take a look at the following document about refresh and improve the performance if this help with your scenario:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |