Recently I’ve been building a lot of Power BI reports from csv and Excel files, and to make sure that scheduled refresh works I have been setting up data sources in an On Premises Data Gateway (what used to be called the Enterprise Gateway). I had assumed that if I was connecting to file-based data sources in my Power BI dataset then, in the gateway, I would need to set up one data source for each file that I’m connecting to – which is a bit of a pain.
We have released a sample application which illustrates how a get a Commerce Gateway solution to work in Microsoft Dynamics NAV 2013. The same solution will apply to Microsoft Dynamics NAV 2013 R2.
The sample shows how you should set up the connection between Microsoft BizTalk and Microsoft Dynamics NAV using a web service. To get the bits for the sample, request hotfix 2892792 from Microsoft Support.