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(252.8, 91%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Data source error: [ValidateMarkupTags][ccon]DataSource.Error: [ccon]Microsoft SQL[/ccon]: [ccon]Error handling external file: 'IO request completed with an error. ERROR = 0x0000000C'. File/External table name: 'ed.Division'.
Statement ID: {74A1DCCE-24BC-4082-B56F-8D239D7B41DB} | Query hash: 0xD3873A2C6BF36204 | Distributed request ID: {B664B13D-3D38-4D5F-84C3-5A970D0BE0EC}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.[/ccon]. DataSourceKind = [ccon]SQL[/ccon]. DataSourcePath = [ccon]synw-dw-prod-nocus-01-ondemand.sql.azuresynapse.net;serverless-db[/ccon]. Message = [ccon]Error handling external file: 'IO request completed with an error. ERROR = 0x0000000C'. File/External table name: 'ed.Division'.
Statement ID: {74A1DCCE-24BC-4082-B56F-8D239D7B41DB} | Query hash: 0xD3873A2C6BF36204 | Distributed request ID: {B664B13D-3D38-4D5F-84C3-5A970D0BE0EC}. Total size of data scanned is 0 megabytes, total size of data moved is 0 megabytes, total size of data written is 0 megabytes.[/ccon]. ErrorCode = [ccon]-2146232060[/ccon]. Number = [ccon]15813[/ccon]. Class = [ccon]16[/ccon]. [/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Division.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 3f7667bb-b4f0-40e3-8c86-7b0157e98f94
Request ID: 2f0491af-6d89-e205-1400-f27fd172bbfd
Time: 2023-10-05 12:39:50Z
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
![](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(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
@Luigi Ruiz Thanks for confirming, is this issue still persistent? or intermittent?
@SatishBoddu-MSFT this is an Azure Synapse since the error occurs when refreshing the data.
Luigi Ruiz Please send us an email with the details as requested in previous response and we will help you in this matter.
Hello @Luigi Ruiz Is this issue related Azure Synapse or Power BI, wanted to check the right Tag/
Based on the error message you provided, it seems that there is an issue with an external file named 'ed.Division' that is being accessed from the Synapse SQL pool.
May i ask if the file is corrupted or supported, or can we verify that by opening in any other application?
Please send us an email on this matter to investigate this issue deeper and help you with one-time support ticket.
Please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Thread URL: Link to this thread.
Subscription ID:
Subject : Attn Satish Boddu
Please let me know once you have done the same