Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Error while loading data from BC to PowerBi

Posted on by 9
Hi , 
 
i have a problem while im trying to load the data from BC to Power BI it works for all the table just for purchase Invoice Lines is not working it gives me this error:
DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (You must specify an Id or a Document Id to get the lines.  CorrelationId:  77c9e642-fc43-4db9-9a84-d79d38f003cc.)

Details:

    DataSourceKind=Dynamics365BusinessCentral

    DataSourcePath=Dynamics365BusinessCentral
 
Kind Regards, 
Alejna 
 
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 4,998 Super User on at
    Error while loading data from BC to PowerBi
    In PBI you can not pull the Purchase Invoice Lines directly, you need to pull the Purchase Invoices API then in there expand the lines.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,134 Super User on at
    Error while loading data from BC to PowerBi
    Hi, You can try contacting Community Support.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    CU02071649-0 Profile Picture
    CU02071649-0 6 on at
    Error while loading data from BC to PowerBi
    Please dear sir my id is locked way reason
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 7,256 Super User on at
    Error while loading data from BC to PowerBi
    Yun Zhu is correct, I believe for that API you need to specific the document no./invoice no.
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,134 Super User on at
    Error while loading data from BC to PowerBi
    Hi, This is very similar to the problem I discussed earlier.
     
    So, this should be standard control, you need to change your Endpoint or add a filter.
     
    Hope this helps.
    Thanks.
    ZHU
  • AM-01071407-0 Profile Picture
    AM-01071407-0 9 on at
    Error while loading data from BC to PowerBi

    Data Source.Error Dynamics365BussinesCentral: Request failed: the remote server returned an error: 400 Bad Request. (You must specify an id or a Document ID to get the lines)

    ​​​​​​​Sorry this is the error 

     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 7,256 Super User on at
    Error while loading data from BC to PowerBi
    It looks like your screenshot was not posted with your message. 
     
  • gdrenteria Profile Picture
    gdrenteria 5,038 Super User on at
    Error while loading data from BC to PowerBi
    Hi
    Please resend the error message or image.
    BR
    Gr

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans