Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Table Information
Small and medium business | Business Central, N...
Suggested answer

Table Information

(0) ShareShare
ReportReport
Posted on by john.ellis 3,494

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,827 Super User 2025 Season 1 on at
    RE: Table Information

    Hi, got it.

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

    pastedimage1674602446350v2.png

    pastedimage1674602438535v1.png

    pastedimage1674602501286v3.png

    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.

    pastedimage1674602634468v4.png

    pastedimage1674602676545v5.png

    Hope this helps.

    Thanks.

    ZHU

  • john.ellis Profile Picture
    john.ellis 3,494 on at
    RE: Table Information

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 81,827 Super User 2025 Season 1 on at
    RE: Table Information

    Hi, yes of cource.

    pastedimage1674523236210v1.png

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

    pastedimage1674523319640v2.png

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

    pastedimage1674523369418v3.png

    Hope this helps.

    Thanks.

    ZHU

  • Philippe P Profile Picture
    Philippe P 55 on at
    RE: Table Information

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,281 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,019 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans