Forum Discussion

Rose__123's avatar
Rose__123
Icon for Helper II rankHelper II
5 years ago
Solved

Error 400 when loading big file from Dynamics 365 Business Central

Hi   I get the following error message every time I try to load specific (probably big) files from Dynamics 365 Business Central: DataSource.Error: Dynamics365BusinessCentral: Request failed: The ...
Need Help
  • Rose__123's avatar
    Rose__123
    5 years ago

    I was able to retrieve the relevant data from Web Services in Dynamics 365 Business Central and then collect them into Power BI from the Web APIs.

averalex's avatar
averalex
New Member
4 years ago

I am still having the same error. Did you ever find a resolution to avoid putting parameters, and just get the entire list of Sales Order Lines in the Power BI?

Rose__123's avatar
Rose__123
Icon for Helper II rankHelper II
4 years ago

I found them using the webservices. In Business Central you can add a page to the available webservices and then you can find them in Power BI. Tell me if you need more guidance 🙂

  • Oggy172's avatar
    Oggy172
    New Member
    1 year ago

    Hi Rose__123 

     

    I have come across this post, only started using BC / Power automate today & don't have a license for PBI.

     

    Do you know of a way I may be able to pull from the *Lines tables in PA? I just need to output them as a CSV on sharepoint/azure blob storage for onward processing in another application.

     

    Thanks