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

Announcements

No record found.

News and Announcements icon
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 :)

  • Suggested answer
    raelhefn Profile Picture
    Microsoft Employee on at
  • 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
    520 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
    Microsoft Employee 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 727 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 512 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 321 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans