Unable to refresh Power BI dataset ERROR = 0x0000000C

Luigi Ruiz 5 Reputation points
2023-10-05T12:44:42.0366667+00:00

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

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,470 questions
{count} vote

2 answers

Sort by: Most helpful
  1. QuantumCache 20,031 Reputation points
    2023-10-05T17:08:36.2233333+00:00

    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

    0 comments No comments

  2. Luigi Ruiz 5 Reputation points
    2023-10-10T12:30:22.89+00:00

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