Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a PBIX file that connects to Synapse Serverless. Specifically, to Views that point to CSV files. The files are being contantly updated by Dynamics FO.
The failure error message is always the same as below, just with a different table referenced.
I bolded the parts that stand out to me:
(I am running a several month old version of the Data Gateway, and just started the beaucratic process to update that, but I doubt it's a Gateway version issue )
Solved! Go to Solution.
I've been able to reproduce this using SSMS - so update, it's not a specific to Power Bi issue
I've been able to reproduce this using SSMS - so update, it's not a specific to Power Bi issue
Hi @mmace1
To me this is happening because you are trying to read from a CSV file which is being written to at the same time.
I would suggest only querying data that is say 1 hour or 2 hours old so that those CSV files are not being written to
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.