We are trying to load the data in power bi through Synapse and we are facing this issue. Can some one help us with a solution.

Pragna Venkata Bhanu Damerla 0 Reputation points
2023-01-12T12:10:16.01+00:00

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: 110806;A distributed query failed: Distribution(s):[2, 12-14, 21, 24-25, 40-41, 44, 58]The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.. An unexpected exception occurred.

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.
5,186 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,245 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Pratik Somaiya 4,206 Reputation points
    2023-01-17T12:54:50.9266667+00:00

    Hello

    This may occur due to the underlying query which you are trying to perform on Synapse

    Can you help me with more details, are you hitting a view in Synapse which is performing some calculations or aggregations or some other stuff which may consume resources?

    Please refer to a similar question here

    0 comments No comments

  2. ShaikMaheer-MSFT 38,506 Reputation points Microsoft Employee
    2023-02-02T14:38:21.1966667+00:00

    Hi Pragna Venkata Bhanu Damerla,

    Thank you for posting query in Microsoft Q&A Platform.

    More queries running on DB or Size of DB is less, then this kind of issue may occur. Could you please try to cancel all queries or Db and try if that helps? Also consider increasing DB Size too.

    Hope this helps. Please let us know how it goes.


    Please consider hitting Accept Answer button. Accepted answers help community as well.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.