The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am currently refreshing a PowerBi report, running in the Power BI service, every 200 seconds. My DBA is reporting that the SQL query is locking for this amount of time. The DB account the report is using is read only - the query only takes seconds to run and return data - it just appears to keep the session open until the next refresh. How do I stop the SQL query locking the DB and close the session?
Hi, the report is force refreshed by the browser every 200 seconds, we have a small team moitoring real time API requests and have 2 reports on a display screen with the browser switching between tabs.
Try using APR instead.
if the issue persists and you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/
I am currently refreshing a PowerBi report, running in the Power BI service, every 200 seconds
Are you using APR (Automatic Page Refresh)?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
42 | |
24 | |
24 | |
23 |