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 , If you have a few view in the SQL server, You need to check it is on how many tables. Those tables have indexes in the join column.

Also, need to check how complex the view is

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

Hi amitchandak 

It is just one view, using 4 tables. View complexity is moderate.

But above all as I said, when running the source query in SQL - it is within fraction of second rerturnin result.

In Power Bi its slow because power bi not executing that one query one time, rather for each visual it is executing that query. That's where I am having a problem.

If I convert everything to import mode, then my PBI is lightening fast and refresh time is also very quick. But I can not really have it in Import mode, because we want to have near real time visibility and that's why I had to go for DirectQuery Approach