Dynamics Community Forum Thread Details

Power BI query and locking BC tables

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 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

Quick Links

Leaderboard