Connection to Power Bi

LewisTiogaLewisTioga Member Posts: 40
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.

Best Answer

  • LewisTiogaLewisTioga Member Posts: 40
    Answer ✓
    Thanks for the feedback but unfortunately the error is still occurring.

Answers

  • krikikriki Member, Moderator Posts: 9,110
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • SaalekSaalek Member Posts: 181
    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
  • LewisTiogaLewisTioga Member Posts: 40
    Answer ✓
    Thanks for the feedback but unfortunately the error is still occurring.
  • SaalekSaalek Member Posts: 181
    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_BoyToddy_Boy Member Posts: 231
    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
    Life is for enjoying ... if you find yourself frowning you're doing something wrong
  • julkifli33julkifli33 Member Posts: 1,087
    hi.. how to solve this issue?
    wphov9i1z4wa.png
Sign In or Register to comment.