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.