mibuso.com
Home› NAV Three Tier
Options

Connection to Power Bi

LewisTiogaLewisTioga 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

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

Answers

  • Options
    krikikriki Member, Moderator Posts: 9,096
    [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!

  • Options
    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
  • Options
    LewisTiogaLewisTioga Member Posts: 40
    Answer ✓
    Thanks for the feedback but unfortunately the error is still occurring.
  • Options
    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
  • Options
    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
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    hi.. how to solve this issue?
    wphov9i1z4wa.png
Sign In or Register to comment.