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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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