Forum Discussion
Intermittent API flows failing to sync
Hi NiallFabric ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
Hi, partially resolved, there seems to be an underlying issue with the new API key method that is making the (smaller than ever before dataflow) eat up more bandwidth.
I've started a Fabric trial and converted the flows to Gen2 flows. They have been running more consitently, and the Gen1s are a little better at manual syncs.
Quite a spendy soloution for a flow that has been larger and previously worked reasonably well with just Power BI pro.
With the trial upgrades, I am getting better error reporting which points to the intermittent failures always happening on one databoard at the source.
<URL> (500): WorkBookMessageException: MashupValueException.
The source platform support can't seem to figure out why but have tried a few things (with no luck). The fact that the Gen2 runs reasonably consistently suggests the API key and parameters may just be making the Gen1 pretty flakey with that platform.
Might need to bite the bullet and add the overhead, for what is a change of login method to a more secure form. Longterm we would move to a different soloution for the cost (even if just F2 and a user account for one dashboard).