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

Is Business central table id 5872 and 5870 available?

(1) Share

Report

Posted on by SC666

266

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Agazziz 215 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,809 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @shine666,

I guess that table is buffer (temporary).

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Gerardo Rentería Ga... 27,507 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

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

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,361 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No