cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shobhitgupta Regular Visitor
Regular Visitor

Direct Queries optimization

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.

5 REPLIES 5
Community Support Team
Community Support Team

Re: Direct Queries optimization

Hi @shobhitgupta ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
shobhitgupta Regular Visitor
Regular Visitor

Re: Direct Queries optimization

@v-shex-msft 

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.

Community Support Team
Community Support Team

Re: Direct Queries optimization

Hi @shobhitgupta ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
shobhitgupta Regular Visitor
Regular Visitor

Re: Direct Queries optimization

@v-shex-msft 

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.

Community Support Team
Community Support Team

Re: Direct Queries optimization

Hi @shobhitgupta ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,763 guests
Please welcome our newest community members: