Forum Discussion

HStapelberg's avatar
HStapelberg
New Member
4 years ago

Error 400 Bad Request when connecting with Standard API to salesCreditMemosLines

Hi   I get this error when I try to connect to salesCreditMemoLine with Standard API, I see the Header tables work, but the lines table gives this error:   DataSource.Error: Dynamics365BusinessCe...
HStapelberg's avatar
HStapelberg
New Member
4 years ago

Hi

Thank you for the response.

 

I find it very strange that Power BI will open salesCreditMemos (Header) table with Standard API v2 but not the salesCreditMemosLines table, as happens with other Lines tables as well.  Header tables does open, it does not makes sense.  I now have to open the salesCreditMemoLines with web services which I see is legacy. 

 

How do I change the connection string in Power BI?  Do I need to to install Power BI Report server and user powershell (I have seen this in an article, but have not used this before.  Should Power BI not open Header and Lines tables with the similiar connection strings?  

 

Thanks

Hendrik

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi HStapelberg ,

     

    I don't have dynamics365, so there is no way to test it. You can try another api.

    Get salesCreditMemos - Business Central | Microsoft Docs

    How to modify the connection string. Modify it through the advanced editor of power query editor.

    Query overview in Power BI Desktop - Power BI | Microsoft Docs
    I hope the provided ones are helpful to you.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • HStapelberg's avatar
      HStapelberg
      New Member
      4 years ago

      Hi

       

      Would it be possible to put me in contact with a Microsoft person who can test Standard AI v2 with Business Central online?

       

      I have used the advanced editor to copy the connection string from a table that works to a Lines table that does not work, and edit the table name, but it still gives the sames error 400 Bad Request.

       

      All tables with "Lines" in the name gives this error, except salesShipmentLines.  This is so weird.