Issue with Power BI Connector to Business Central after update to 23.1

[Shaishavm]

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;

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

Hope someone can share light on this issue.

TIA!

Regards,

SM

[v-binbinyu-msft]

Hi @Shaishavm ,

Please try to connect Dynamics 365 Business Central with the built-in connector by Power BI Desktop.

For more details, you could read related document: Building Reports in Power BI Desktop to Display Business Central Data - Business Central | Microsoft...

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shaishavm]

Hi, Thanks for your messsage. We are using Power BI connector to BC for reports. It has been working all the while, however, after updating BC environment to 23.1 it started failing to retrive General Journal data.