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.
Super UserHI 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?
MacJasemHi 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.- MacJasem
BTW
I'm using the Business Central connector to retrieve data from the KPI Finance Report webservice in Business Central.
- 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-menakakotaCommunity Support
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?