web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Add a Custom Table from Business Central (on prem) to Power Apps

(0) ShareShare
ReportReport
Posted on by 5

Hello beautiful People,

I have a problem and hope you can help me out.

I want to use Data from a Business Central (On Premise) Database for a PowerApp.

Just managed to get a connection to my Data but i just can use predefined tables.

Is there a way to use Custom defined tabels like in this picture ?  If i type in the custom tables we use in the Database it cant find them.

pastedimage1586869078840v1.png

If you can help me, i would appreciate it !

Thanks Mates :)

I have the same question (0)
  • Suggested answer
    raelhefn Profile Picture
    on at

    Hi thegreatdensby,

    please have a look to the following posts it can help you to find the best scenario in this case:

    msdynamicsworld.com/.../working-microsoft-dynamics-365-business-central-customizations-powerapps-using-cds-and-odata

    community.dynamics.com/.../powerapps-integration-with-microsoft-dynamics-365-business-central-online

  • Community Member Profile Picture
    on at

    1. Create a custom entity within Common Data Service(CDS) whose data you want to retrieve from Business Central.

    2. Add the fields with their required data types.

    3. Get Data from Business Central using OData Integration.

    4. Go to web services in Business Central, add the custom page in the web services and use its OData V4 URL.

    5.Enter the OData URL and the Organization credentials.

    6. You will be shown the list of tables in each and every company.

    7. Go to the table whose data you want to get into PowerApps, and select that table.

    8. Next is to select the entity to be mapped with this table and field by field mapping of the same.

    9. Refresh can be set manual or automatically, if automatic then select the time.

    10. Create a list structure to dsiplay the table.

    Admin

    Apps4rent | o365cloudexperts

  • Y_A Profile Picture
    395 on at

    thegreatdensby

    Hi, a question further to the above - I need to connect BC on-prem to Power apps and have two main questions;

    1. The instance I will be connecting to needs to have a valid SSL Certificate? i.e. do I need to buy an SSL Certificate and include the certificate thumbprint in the BC Instance? (via the Administration)

    pastedimage1602672965478v1.png

    2. Does a Windows Authentication instance work or is it better to have NAVUserPassword authentication? 

    Thank you in advance!. 

  • Suggested answer
    raelhefn Profile Picture
    on at

    1. The instance I will be connecting to needs to have a valid SSL Certificate? i.e. do I need to buy an SSL Certificate and include the certificate thumbprint in the BC Instance? Prefer to by license specially for production

    2. Does a Windows Authentication instance work or is it better to have NAVUserPassword authentication?

    To prepare your Dynamics NAV instance for usage with Power BI it requires you to have a credential type “NavUserPassword”.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans