Connecting to NAV/BC on-premise data

[JMGCORNATOR]

Hi there,

So i am trying to connect powerapps to Microsoft Dynamics NAV and Microsoft Business Central. For now i am mostly interested in testing how to connect Powerapps to NAV as most of our customers use NAV. I am running a Per-user license. Data is locally stored i.e. not located in Azure. Using Common Data Service is not an option.

I wonder if anyone has experience using the Dynamics NAV connector to access local NAV data? Do i need any adjustments of my firewalls? Or does anyone have some other tricks up their sleves? 

Accessing the data using SQL and a gateway has been successfully testet, but comes with restrictions, so it does not quite do the job for me.

Hit me with any suggestions 👌

[v-siky-msft]

Hi @JMGCORNATOR ,

I'm not a expert on D365, but I found some similar threads or related blogs for your reference, hope these can help you.

Create apps with PowerApps and Dynamics NAV 

Connect Dynamics NAV and Microsoft PowerApps 

How To Connect OnPremise NAV to PowerApps/PowerBI Content Packs 

Best regards,

Sik

[JMGCORNATOR]

Hi @v-siky-msft,

Thanks for your reply! I have already read the same (and some other) links prior to my post 😁

// J