Forum Discussion
Performance Improvement
Hi All,
Let us assume i have 100 rows of data and i want to show data for 1 department alone in front end visualization that contains 20 rows.
Now i have to option
1. To create a measure and in that dax i can put Calculate(Sum([Sales]),Department="A") and drag it in chart
2. To restrict in Visual level filter.
Which one is good for performance improvement in direct query mode as well as in import mode?
Thanks in Advance
- Anonymous6 years ago
HI Anonymous,
Maybe you can take a look at following links about tricks to improve performance:
Optimization guide for Power BI
A comprehensive guide to Power BI performance tuning
Regards,Xiaoxin Sheng
3 Replies
- AnonymousNot applicable
HI Anonymous,
Maybe you can take a look at following links about tricks to improve performance:
Optimization guide for Power BI
A comprehensive guide to Power BI performance tuning
Regards,Xiaoxin Sheng
- amitchandakSuper User
Anonymous ,
You should use calculate in case of direct query.