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
AnandRanga
Helper III
Helper III

adding a dataset of OData web service url of NAV from power bi online ?

I am trying to add a dataset from poewr bi online using add data source option. I am entering the url of web service. that url is working fine, i have tested that.

Authentication type is basic, then i am supplying username and password.

but it is giving me this error:

 

Unable to connect: We encountered an error while trying to connect to https://abcxyz.financials.dynamics.com:1234/MS/ODataV4/Company('CRONUS%20Canada')/ItemList?

Details: "The gateway is either offline or could not be reached."Hide details

Activity ID:a73ca50e-478d-b558-1155-45a1d46f0765
Request ID:9aa2667e-a231-ef3e-851b-19e2f63018b1
Cluster URI:https://wabi-west-us-redirect.analysis.windows.net
Status code:400
Error Code:DM_GWPipeline_Client_GatewayUnreachable
Time:Fri Jul 07 2017 17:53:35 GMT+0530 (India Standard Time)
Version:13.0.1828.174

 

why I am facing this error ? Any idea? 

Actually I am planning to create a dataset on power bi online and then I will assign this data source to some dashboard, so that I don't need to use power bi desktop.

 

Thanks 

2 REPLIES 2
v-sihou-msft
Employee
Employee

@AnandRanga

 

As the error message indicated:

 

The gateway is either offline or could not be reached.

 

You need to install either Personal or On-premise Gateway on the machine where hosts NAV. Make sure it's started and you have sign-in with your Power BI Account.

 

Reference:
Getting started with Power BI Gateways

 

Regards,

 

this OData web service is from dynamics NAV, that is hosted on cloud. I can't install gateway there.

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.