Forum Discussion
Power BI Challenges with huge data volume
- 2 years ago
ZikoPowerBI
with that king of large data you are expected to face performance issue, to improve performance you can consider below;
check the table relationships, indexing, and data types.If your data is time-series data like daily records, consider partitioning your data in your data source. Partitioning can really improve query performance, especially when retrieving data for specific time periods.
try to load your data incrementally by applying incremental refresh.
if your report is slow then try to use the performance analyzer option to know which calculation or dax is taking too much time and try to optimise it.
My blog:
https://analyticpulse.blogspot.com/2024/03/superstore-sales-2022-vs-2023-year-on.html
https://analyticpulse.blogspot.com/
https://analyticpulse.blogspot.com/2024/04/case-study-powerbi-dashboard-developer.html
https://analyticpulse.blogspot.com/2024/05/what-if-sun-disappeared.htmlSee my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/