Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sergii1988
Regular Visitor

OLE DB or ODBC error: file 'xldqsqlqueryfragment.cpp', line 105, function 'GenASQLTypeInternal'

Hi guys,

 

In our architecture we have main model, which is used by all reports (in Composite mode). Few weeks ago we encountered an error

sergii1988_0-1663238724194.png

 

We found that it is related to Calculation Groups, if Calulation Item contains arithmetic operation 

example:

SELECTEDMEASURE() + 1

issue appears,if we remove any arithmetic operations

example:

SELECTEDMEASURE()

 everithing works fine. Note in the visualization there are no measures which use Calculation Items.
In example above there is one simple measure: CNT Rows = COUNTROWS(SEATS). And column from the same table

sergii1988_1-1663239235378.png

 

 

Trace file info:

DataMashup.Trace Information: 24579 :
{
"Start": "2022-09-15T10:37:09.1702136Z",
"Action": "PBI.DS.ExecuteSemanticQueryInfo",
"message": "{\"ID\":\"0\",\"DSQG\":{\"NumSelects\":3,\"Reduction\":{\"DataVolume\":3,\"MaxInters\":1000,\"Primary\":{\"Init\":{\"Kind\":\"Top\"},\"Final\":{\"Kind\":\"Top\",\"Args\":[\"1000\"]}}}},\"DSQT\":{\"QueryPattern\":\"SuperDax\",\"Constraints\":[{\"Id\":\"DS0\",\"GroupEntities\":1,\"TotalM\":1,\"RelatedM\":1}]},\"PROC\":{\"ConnCategory\":\"Internal\",\"DsrVersion\":2},\"ERR\":\"Details: ErrorCode=QueryUserError, ProviderErrorCode=0xC1060000, ErrorSource=User, Message=Failed to move the data reader to the next row., HResult=0x80004005, Language=en-US, ProviderErrorMessage=[<ccon>OLE DB or ODBC error: An unexpected error occurred (file 'xldqsqlqueryfragment.cpp', line 105, function 'GenASQLTypeInternal'). \\n \\nTechnical Details: \\nRootActivityId: 018104bc-dd55-45be-b0eb-1eeeecf9e892 \\nDate (UTC): 9/15/2022 10:37:08 AM.</ccon>], ProviderGenericMessage=[OLE DB error: OLE DB or ODBC error.], ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Failure encountered while getting the next row in the result-set]\",\"MODEL\":{\"Caption\":\"<ccon>d4b2094c-f47d-49f3-bc1b-93db95390a63</ccon>\",\"Entities\":58,\"EntitiesNameLength\":702,\"Props\":824,\"PropsNameLength\":16047,\"Rel1To1\":18,\"Rel1ToM\":73,\"Kind\":\"Tabular\"},\"METRICS\":{\"Requested\":1,\"Actual\":1,\"Query\":1,\"Events\":5}}",
"sessionId": "88c7412d-cc4a-4d72-8497-40301a70100a",
"deviceId": "b104405e",
"userId": "61a965f4-3a18-4b15-acd9-96e30a31d01a",
"isInternal": "False",
"authenticatedUserId": "9abbc246-c159-4b49-85cf-1587501260d5",
"ProductVersion": "2.109.642.0 (22.09)",
"ActivityId": "ed2f67f2-81d3-409c-9991-41db6699a299",
"Process": "PBIDesktop",
"Pid": 21948,
"Tid": 12,
"Duration": "00:00:00.0003830"
}

2 REPLIES 2
v-yadongf-msft
Community Support
Community Support

Hi @sergii1988 ,

 

Please check the type of the column, maybe the error is caused by the incorrect type of the column.

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yadongf-msft

When I choose Table visualization, everything works fine

sergii1988_4-1663497842897.png

 

And if I shwitch to donut chart, the issue appears, not sure this is related to column type.

 

sergii1988_2-1663497507021.png

Before September everything worked fine, we didn't add any changes to our main model

Also in the trace file I see error message 

ErrorSource=User, Message=Failed to move the data reader to the next row.

 

PREVIEW
 
 
 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.