Forum Discussion
How to avoid poor performance when the data base has millions of records
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
Hello,
Thanks for your feedback.
I will need refresh data two or three times during the work hours!
Using import mode is a good solution? Or the best solution it is create several views in SQL Server and import them?
Best regards.
Hi Anonymous
You can create a single view using joins and then call in a single table or connect to multiple tables would require you to build the relationship in PBI. So that depends on your requirement, both of them won't have any effect on your model performance.