Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
24 | |
19 | |
16 |
User | Count |
---|---|
52 | |
38 | |
24 | |
20 | |
20 |