Connection to Power Bi

LewisTioga

We are trying to implement the use of Power BI Dashboards within or business. I am connecting Power Bi to our Nav Database via an OData connection. The connection works fine and data comes through as expected, no worries here. However If I log into Navision or have it open (Have a connection) i get the following Error When I try and do anything essentially, i.e refresh, Modify Queries etc.

DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
Details:
DataSourceKind=OData
DataSourcePath= (This would be my OData Path)
Any ideas will be appreciated.

LewisTioga

Thanks for the feedback but unfortunately the error is still occurring.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Saalek

Hi

Usually then error 400 is because there is some problem with servername/ip relation.
Try to change your odata connection, using server IP instead servername.

Regard

LewisTioga

Thanks for the feedback but unfortunately the error is still occurring.

Saalek

hi

Do you tried the odata opening with excel to test it ?
And remember you can't modify odata info. Odata is used as read only

Regards

Toddy_Boy

We are suffering with the same problem. We can sometimes refresh the document but the second time the refresh is tried we get either Bad Request or a Mashup error.

The URL works fine in Excel.
Tried replacing server name with IP address.
The OData is on it's own service

julkifli33

hi.. how to solve this issue?