Forum Discussion
How to avoid poor performance when the data base has millions of records
Hello Everyone, very soon i will build a PowerBi report based on data base in SQL Server with million of records. But, I am concerned with performance! In your opinion: What is the best wa...
You should not use Direct Query if you can avoid it. Import mode is more performant. Here are some key things to consider:
- Use import mode
- Create a star schema data model
- Only bring in the data you need (remove any unneeded columns/rows)
- Avoid DateTime and Decimal columns (split into Date and Time, used Fixed Decimal)
- Leverage incremental refresh to minimize refresh times
Pat
I just made a tutorial today talking about dealing with million records and things to do to speeden up your report. Hope this helps.
Reasons why your Power BI report is slow & how to optimize | Performance Tuning | MiTutorials