This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 50%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEL%3C/text%3E%3C/svg%3E)
Hi guys,
we have the following setup:
A "SELECT TOP 100" statement always works. But I have an issue when I set up serious queries: in 8 out of 10 cases it throws an error: Cannot bulk load because the file "https://p.../opportunity/2022-03.csv" could not be opened. Operating system error code 12(The access code is invalid.).
As far as I read this is because there are changes written to that file while I am quering it. I have read about the ALLOW_INCONSISTENT_READS option here, but I have no idea where so set this up, as the lake database was autogenerated when configuring the synapse link.
How should one query the data in the lake database to avoid this error? I can't build applications on top of that data if 8 out of 10 queries fail. Any help would be greatly appreciated!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hello @Esser, Lukas (ADM) ,
Thanks for the question and using MS Q&A platform.
Just to summarize the ask - you are receiving the above error message, when trying to query Azure Data Lake files which were exported by Azure Synapse link from Dataverse. Please correct if my understanding is incorrect.
Could you please confirm if you are using Azure Synapse Link for Dataverse with Azure Data Lake or Azure Synapse Link for Dataverse with your Azure Synapse Workspace? If you are using Synapse link for Dataverse with Data lake then you can query the files as below to avoid the above issue.
For more info, please refer to this doc - Querying appendable files
In case if you are using Azure Synapse Link for Dataverse with your Azure Synapse Workspace then please let us know so that we may have to reach out to respective product team to get additional information regarding this use case.
Thank you
Hello @Esser, Lukas (ADM) ,
Just checking in to see if the above information was helpful. Do let us know if you have further questions.
Thank you
Hi @KranthiPakala-MSFT ,
thank you for your reply! We have configured the Synapse Link for Dataverse with Synapse Workspace (your second link): https://learn.microsoft.com/en-us/powerapps/maker/data-platform/azure-synapse-link-synapse
Therefore, I can't add the ROWSET OPTIONS, as I don't read the data with an openrowset() statement. The tables that I am trying to query are autogenerated by the Synapse Link in a so-called "lake database" in my Synapse workspace.
Hello @Esser, Lukas (ADM) ,
Thanks for confirming. We have reached out to respective product owners to get additional information about your requirement and will get back to you as soon as we have a response from the team.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Just thought I'd add a small bit of information that might help. I've configured the Synapse Link for Dataverse in the same way, and I'm having the exact same error as above. I can't edit any of the auto-generated tables in the replicated database due to Operation CREATE EXTERNAL TABLE is not allowed for a replicated database, but I can "fix" the error by recreating the same resources in another database.
For example, if I create the same external file format and external data source, then create the same external table but add: TABLE_OPTIONS = N'{"READ_OPTIONS":["ALLOW_INCONSISTENT_READS"]}' then I can access the entire table without error.
This doesn't seem to be a great option for the entire replication, as I'm essentially replicating the entire "auto-generated" database in order to add a single option into each table, but it might help for troubleshooting or as a quick fix while the issue is being looked into.
Hello @Esser, Lukas (ADM) , @Jeffrey Truscott ,
Update: The product team have confirmed that it is known issue and they are working on a fix for it, but we do not have an ETA at this point. I will continue to follow-up with respective team on the progress for this fix and update here once I hear back more updates from the team.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
I am too getting the same error. Hope Microsoft fixes this issue soon as our production environments are affected because of this.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 13%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Hey @KranthiPakala-MSFT , just wondering if there are any updates on this,
I've done exactly the same thing,
Although I'm connecting to a View in another Synapse db that uses 2 Tables from an Azure Synapse Link for Dataverse with an Azure Synapse Workspace to generate various Power BI reports on Dynamics data.
I get various errors when selecting various values in Slicers
Is there an ETA for this, it has now been almost 4 months since it was acknowledged as a known bug
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Hi @KranthiPakala-MSFT ,
I have got the same issue.
Do you have any update from the product-team in regard to this bug?
it's worrying if the plan is that Synapse Link is going to used instead of the soon to be deprecated data export service
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 20%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Same here. I am also worried about the timeline of the decommission of DES. If this isn't working, we have no other alternative.
5 Months - Any update?
Hello everyone,
As per the recent conversation with Product team, they have recently released a public preview feature called Snapshot data and for tables with continuous changes and facing above error, the recommendation is to change your consumption pipeline to use snapshot data (partitioned tables) rather than pointing to the original tables.
Please refer to this public document suggestion by product team: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/export-data-lake-faq#why-do-i-see-the-error-message---cannot-bulk-load-because-the-file-is-incomplete-or-could-not-be-read
Below are additional approaches to overcome this issue:
Hope this info helps.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
If this has been established as a bug then may I ask when the fix will be rolled out, rather than work around the issue but querying partitioned tables? Thanks.