Unable to refresh Power BI dataset ERROR = 0x0000000C

Question

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

Answer 1

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

Answer 2

@SatishBoddu-MSFT this is an Azure Synapse since the error occurs when refreshing the data.