Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |