Direct Queries optimization

[Anonymous]

Hey, I am facing higher lags with direct query report as it is getting locking conflicts with the SQL DB source tables.

I am trying to find a way to remove that lock, unable to find a solution. It would be great if someone can guide me to the right approach.

[Anonymous]

Hi @Anonymous ,

You can consider to use sql profiler to trace queries which power bi generated:

How to turn on SSAS profiler traces in Power BI desktop

Power BI performance best practices

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous 

Hi, I have tried using SQL profiler it is performing queries in milliseconds but when opened in power bi embedded they are taking longer time. We find out sometimes there are locks in the sql tables while accessing the table using power bi from multiple users while updating tables. how to avoid that, are  there any best practices documented for power bi embedded.

[Anonymous]

Hi @Anonymous ,

What type of embed you mean? Publish to web or power bi embedded? How did you setting sql database maximum sessions amount? AFAIK, power bi not contains writeback operational database and user view request should works in same sessions.

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous 

It is Power BI Embedded.

I am aware of the fact that power bi does not have native writebacks. Our application write its output in db as per user request and power bi displays the result of it with historical info. Somehow it is getting locked up with db read and write processes.

[Anonymous]

Hi @Anonymous ,

Have many records your db has? Can you confirm your device has enough idle memory resource(RAM) to processing refresh operation? If this is a case, power bi refresh requests will been block/canceled due to memory resource(RAM) issues.
Regards,

Xiaoxin Sheng