web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Power BI query and loc...
Small and medium business | Business Central, N...
Answered

Power BI query and locking BC tables

(0) ShareShare
ReportReport
Posted on by Samantha73 3,297

Hi All

Now that we are jumping on the power BI bandwagon I thought I'll ask a question on how Power BI reports working on pages and APIs work (BC SaaS).  Let assume I'm exposing the item ledger entry table via webservice page and consume it through Power BI.  Does this cause the table to lock while a user is running a report in Power BI? What are the options for a scalable solution when it comes to tables with a lot of data?

Thanks

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,583 on at

    Hi

    I am sure people with more Power BI information can provide more answer. This is my experience

    You can setup "refresh" time for Power BI. Which means report will only refresh on certain times (after hours maybe).

    We have a few Power BI reports and I tried to refresh them and at the same time work with the same table. I did not notice any table lock. 

    In addition, I monitored our Application Insights and did not see any lockout during run time of Power BI. 

    All that being said in SaaS version they are limitation for such a request (run time). I tried to run a few Jet Reports on bigger table and users have experienced slow down in BC performance. I know Power BI uses ODATA (Jet recently provided same option as well) and that may have less impact on allowable run time. But never had a chance to test it. 

    docs.microsoft.com/.../operational-limits-online

    Thanks 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,821 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,122 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans