Forum Discussion
Advocate IIFailing Dataflow refreshes when datasource is Business Central (Financial Report KPI web service)
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.
Advocate IIThis 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?
Community SupportHi 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
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.