Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Aigars
Regular Visitor

Can't refresh "Dynamics NAV" data source using Power BI Gateway

Hello,

We have production server Dynamics NAV 2017 available only in local network (LAN). Using Power BI Desktop we have created Power BI Report. As data source we use DynamicsNAV and Excel file. All information succsefully refresh to Power BI Desktop during development. After we publish report to Power BI Service, we can't refresh it anymore. Power BI Gateway version : 3000.110.5

Excel file sucsesfully maped with dataset, but Dynamics NAV not mapping, I have tried to press "Manually add to gateway" and add it manually, but nothing changes after I've create data source.

Any ideas?

 

AigarsJ_0-1643993244991.png

AigarsJ_1-1643993689764.png

AigarsJ_2-1643993907989.png

 

 

1 ACCEPTED SOLUTION
Aigars
Regular Visitor

I got answer from Microsoft Support. Basically "Dynamics NAV" data source can't be used with Power BI Gateway, so I we will use "OData Feed" data source. Hops this information will help someone 🙂

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

AigarsJ_0-1644240275307.pngAigarsJ_1-1644240304412.png

 

 

 

View solution in original post

3 REPLIES 3
Aigars
Regular Visitor

I got answer from Microsoft Support. Basically "Dynamics NAV" data source can't be used with Power BI Gateway, so I we will use "OData Feed" data source. Hops this information will help someone 🙂

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

AigarsJ_0-1644240275307.pngAigarsJ_1-1644240304412.png

 

 

 

Aigars
Regular Visitor

Doesn't help.

AigarsJ_0-1644227745450.png

 

v-jayw-msft
Community Support
Community Support

Hi @Aigars ,

 

Try this:

Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors