Forum Discussion

RKM's avatar
RKM
Icon for Helper IV rankHelper IV
4 years ago

Directquery Performance And Each visual executing query in SQL Server - Any ways to improve?

I want to understand this scenario a little better from you experts... I have a simple dashboard with 3 tables. 2 out of those 3 are hardcoded value tables [Enter Data in Power Bi] and having 4 and ...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

RKM , Do you have bi-directional joins.

If yes, Try to avoid that.

Second, make sure you have index in the join columns

 

Please share sample data model