Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Version 23.1 and issues with Power BI connector

Posted on by 215
Hi Friends,
 
Noticed that after updating the BC version to 23.1, we are unable to access General Journal table using Web Services (Legacy) for Power BI connector.
I am reciving following error message;
 
DataSource.Error: Dynamics365BusinessCentral: Request failed: The remote server returned an error: (400) Bad Request. (Specify a filter for the Journal Template Name field in the Gen. Journal Line table.  CorrelationId:  a6de04a5-cda2-42ff-943d-fa9e808a1cac.)Details:    DataSourceKind=Dynamics365BusinessCentral    DataSourcePath=Dynamics365BusinessCentral
Hope someone can share light on this issue.
 
TIA!
 
Regards,
SM
Categories:
  • ShaishavM Profile Picture
    ShaishavM 215 on at
    Version 23.1 and issues with Power BI connector
    Hi Judy,
     
    Thanks for your reply.
    I tried adding the filter without success. Moreover, Power BI connector to Business Central doesn't pass filtered data.
     
    Let me know should you have any other suggestion.
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Version 23.1 and issues with Power BI connector
    Hi Sir,
     
    For the error messages, could you please try to specify a filter for the Journal Template Name field in the Gen. Journal Line table.
    Please check the Microsoft Document to build Power BI Reports to Display Dynamics 365 Business Central Data:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans