Small and medium business | Business Central, N...

Is Business central table id 5872 and 5870 available?

(1) Share

Report

Posted on by SC666

104

Hello,

May I know if table 5872 and 5870 is available?

I created page 5872 and 5870 page under Business central web services. When using Power BI to get the data by connecting to Business central, it showed error as below:

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 86,253 Super User 2025 Season 1 on at

Like (0)

Report

Is Business central table id 5872 and 5870 available?

Hi, if SourceTableTemporary = true;, if you open this page directly through Web Service, there will be no data. There are many similar pages in BC. If you want data, you need to customize the logic of the data it retrieves.

Hope this helps as well.

Thanks.

ZHU
Gerardo Rentería Ga... 21,118 Most Valuable Professional on at

Like (0)

Report

Is Business central table id 5872 and 5870 available?

Hi

The name of the field you indicate or the URL. are they correct?

BR

GR
Suggested answer

Mohamed Amine Mahmoudi 24,676 Super User 2025 Season 1 on at

Like (0)

Report

Is Business central table id 5872 and 5870 available?

Hi @shine666,

I guess that table is buffer (temporary).

Best regards,

Mohamed Amine MAHMOUDI
Agazziz 203 on at

Like (0)

Report

Is Business central table id 5872 and 5870 available?

Unfortunately, no - you won't be able to query that data. Notice how under the Table name in Page Inspection, it says "The source table of this page is temporary." This means that Business Central is creating a temporary table that isn't stored anywhere, so the data can't be queried.

Another example of this is the Effective Permissions Page: