Failing Dataflow refreshes when datasource is Business Central (Financial Report KPI web service)

[MacJasem]

Hey all

Hope someone can help make sense of this Dataflow refresh Failure i keep getting every second time my dataflow is executing the scheduled refresh, and when the refresh fails i've found out that i just have to open the Dataflow and select the Query that gets the KPI Finance Report data from the Business Central webservice, and let it load and then apply and close the dataflow edit again. Then run a dataflow refresh and the failure does not occure again.

This is the webservice:

Any idea why every second time the scheduled refresh of dataflow fails because of this specifict datasource?
Anybody else experienced this issue?

[v-menakakota]

Hi @MacJasem ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-menakakota]

Hi @MacJasem,

May I ask if you have resolved this issue?If not,could you please provide more information as suggested by collinq so that it will help us to investigate further.

Thank you and Regards,
Menaka.

[collinq]

HI @MacJasem ,

Do you have a more descriptive error message?  Also, is this in "My Workspace" or in a different workspace?  And, what is your permissions in that workspace?

[MacJasem]

This is what i see everytime the dataflow has failed

I have a theory that it fails because the KPI Finance Report webservice in Business Central buffers every 3 minutes, and if my Scheduled Refresh triggers while the webservice is buffering, then it fails, and therefore why only the table that gets data from this webservice is the sole reason why the entire dataflow refresh fails.

If this is the case, do you have an idea on how to solve this issue og perhaps a workaround?  

[v-menakakota]

Hi @MacJasem ,

If the refresh triggers during buffering, the data retrieval may be temporarily unavailable, causing the Dataflow refresh to fail.
1.Schedule the refresh at a time when the web service is less likely to be buffering. If buffering occurs every 3 minutes, try adjusting the refresh  intervals to minimize conflicts.

2.Use Power Automate to initiate a retry whenever a failure occurs. Configure a flow to detect failures and automatically attempt a retry after a few minutes.Rather than performing a single refresh, break it into multiple steps first, load all other tables, then refresh the KPI Finance Report data separately.

 Try adjusting the refresh schedule first this is the easiest fix. If that doesn’t work, Power Automate retries error handling could be a good workaround.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[MacJasem]

Thanks @v-menakakota for the reply

As of now i have tried creating a new Dataflow on another workspace and i can not get access to the Business Central KPI Finance Report webservice.

It seems as if the webservice is not connecting with both a Odata connection or with the PowerBI Business Central connector. 

Any idea why or there might be a Microsoft update that has caused a bug?

[v-menakakota · Accepted solution]

Hi @MacJasem  ,

Since you’re now unable to connect to the Business Central KPI Finance Report web service using both OData and the Power BI Business Central connector,please raise a support ticket.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!

Regards,
Menaka.

[v-menakakota]

Hi @MacJasem ,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

Regards,
Menaka.

[MacJasem]

Hi @v-menakakota 

No solution has been found yet.

[MacJasem]

BTW

I'm using the Business Central connector to retrieve data from the KPI Finance Report webservice in Business Central.

[MacJasem]

Hi @collinq 

Nothing else than an error on the dataflow, and a message about the dataflow failed during scheduled refresh. When i download the csv error report the indicator says that the table with the Source (Business Central) KPI Finance Report table failed.

The dataflow is not on My Workspace but in another dedicated workspace where i have Admin rights.