Manual refresh error

[PraveenDenduluri]

What is the bug?
We are experiencing an intermittent issue with manual refreshes failing unpredictably. We are using the OpenSearch SQL ODBC driver, and while the refresh works at times, it occasionally fails without a clear pattern.

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Go to the report in the workspace
2. Click on refresh icon
3. Press on the error button
4. See error

What is the expected behavior?
A refreshed Power BI report is to successfully retrieve the latest data from connected sources, update all visuals and calculations without errors, complete efficiently within a reasonable time frame, preserve customizations, and provide logs or alerts for any failures.

What is your host/environment?

• OS: Microsoft Windows 10 Enterprise
• Version: 10.0.19045.5131
• Plugins : ODBC driver version: 1.05.00.00

Do you have any screenshots?
Yes,

Do you have any additional context?
We are experiencing an intermittent issue with manual refreshes failing. We are using the OpenSearch SQL ODBC driver, and while the refresh succeeds at times, it occasionally fails without a clear reason.

[dblock]

[Catch All Triage - 1, 2, 3, 4, 5, 6]

[acarbonetto]

Would you be able to try and keep all errors as per https://community.fabric.microsoft.com/t5/Dataflow/Mashup-Exception-Expression-Error-DataFlows-2-Gen/m-p/4149374?
This seems like a Power BI mashup error. Could you check the driver logs for any additional errors?

[acarbonetto]

This behaviour can be seen if a GetInfo request is made using an unsupported InfoValue (we only support up to ODBC 3.51).

See: https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgetinfo-function?view=sql-server-ver16

[ykmr1224]

After communication with Microsoft, we found SQL_SQL_CONFORMANCE specified in ODBC connector is SQL_SC_SQL92_INTERMEDIATE, and in ODBC driver is SQL_SC_SQL92_ENTRY.