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

Table Information

(0) Share

Report

Posted on by john.ellis

3,510

Hi:

Is it possible to grant users access to the "Table Information" window, within Business Central?

Also, is it possible to export data from "Table Information"?

Thanks!

John

I have the same question (0)

All responses (4)

Answers (0)

Philippe P 55 on at

Like (0)

Report

yes it is possible. I suggest you read about autorisations and security for the users access to the "Table Information" window.

You could export data in a multiple ways. Either by simply exporting to excel directly on the page. Otherwise you could create a pack with Pack config or a web services.

Cheers

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

Hi, yes of cource.

You can use the following three objects to set permissions for Table Information page.

For export, it is most convenient to use Open In Excel.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

@Zhu: Thanks! But, on your final screenshot, I'm referring to exporting to Excel after you drill down into the table. :) John

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, got it.

Drilling down the table directly on this page is actually the same as running the table directly in the browser.

More details: View a table object directly from the client

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-view-table-data#view-a-table-object-directly-from-the-client

You must have tested that in this mode, it is impossible to export all the data.

The solution is to use Configuration Package. Because you already have the company name and the ID of the table in Table Information, although it is a bit troublesome, this is a possible method.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No