Forum Discussion
Strategy - Optimize Power BI report
Hi,
I am looking for suggestions to optimize my Power BI reports. Please help me. Thanks,
Situation:
I have a complex power bi report which consist of prevous year's data and current year's data. I need to categorize the current data before I can append the previous year's data. In the past, I have never be able to auto-refresh my current year's data if I have all my steps in Power Query.
For the current year's data, I need to merge the data with some look-up tables in order to categorize the data. The look-up tables need to be updated frequently, and stored in SharePoint. And the current year's database is a big database which usually is slow loading. As far as I know, merging is not recommended and is an expensive step. But I can't append the current year's data with previous year's data until I categorize the data with look-up tables using merging.
Is there any other way to avoid merging? So far, I am able to auto-refresh the current year's data using dataflow. Thanks,
1 Reply
hello Anonymous ,
Also for better performance try building the model as star schema Model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
also, remove the columns that you wont be using in your analysis.
you might need to use incremental refresh on the current year database you have.
check incremental refresh https://youtu.be/Kui_1G6kQIQ?si=SSojPeQIj8gXo7dB
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
