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

Is Business central table id 5872 and 5870 available?

(1) Share

Report

Posted on by SC666

241

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)

Agazziz 213 on at

Like (0)

Report

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,434 Super User 2025 Season 2 on at

Like (0)

Report

Hi @shine666,

I guess that table is buffer (temporary).

Best regards,

Mohamed Amine MAHMOUDI

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

Like (0)

Report

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 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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