Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
4 | |
3 | |
3 | |
2 |