Forum Discussion
Intermittent error refreshing in service, from Synapse Serverless
I've been able to reproduce this using SSMS - so update, it's not a specific to Power Bi issue
That was actually my thinking too - I have a timer set to see if failures are less frequent tonight, when (presumably) the files are updating less.
There's no way to limit to 'few hours old' data - these are hot files. Unless we undertook some data engineering effort to complicate our setup.
It is weird though - SQL Querying is fine, PBI Desktop is fine, its only in the service that the issue is coming up.
Hi, have you solved this issue? I experience the same.
We also thought...think actually it is related to the csv files being accessed by the synchronisation from D365.
However, I'm able to SELECT * from the views that cause problems in the refresh within the PBI service.
The SELECT does finish in minutes without a single problem.
Refresh in service brings this error message.