Connection to Power Bi

LewisTioga
LewisTioga Member Posts: 40
in NAV Three Tier
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

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

Answers

  • kriki
    kriki Member, Moderator Posts: 9,127
    [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!

  • Saalek
    Saalek 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
  • LewisTioga
    LewisTioga Member Posts: 40
    Answer ✓
    Thanks for the feedback but unfortunately the error is still occurring.
  • Saalek
    Saalek 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_Boy
    Toddy_Boy Member Posts: 232
    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
  • julkifli33
    julkifli33 Member Posts: 1,100
    hi.. how to solve this issue?
    wphov9i1z4wa.png

Categories