Forum Discussion
Solved
Power BI Server - Refresh failing in random manner for same data set via ODBC connection
We're experiencing an issue where refresh works successfully sometimes and fails at sometime. Do we have any limitations on back to back on-demand for a same report? What are all the possible soluti...
Hello guys,
The root cause of this issue is Container exited error, we detected from gateway logs.
The error was fixed at the driver level due to multiple handle required for different use cases for a same report to refresh. Hence handling the allocation will fix this.
We are using Premium capacity and ODBC data source
TemplateMessage: Mashup expression evaluation error. Reason: DataSource.Error.
Line 881: GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Line 884: Reason=DataSource.Error
Line 889: MessageParameters=[ODBC;<ccon>An error occurred but no ODBC error information was available.</ccon>]
Line 891: [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<ccon>ODBC: An error occurred but no ODBC error information was available.</ccon>
Line 893: GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
Line 896: InnerMessage=<ccon>ODBC: An error occurred but no ODBC error information was available.</ccon>
Line 897: InnerToString=<ccon>Microsoft.Data.Mashup.MashupValueException (0x80004005): ODBC: An error occurred but no ODBC error information was available.
Search "error" (1669 hits in 12 files of 29 searched) [Normal]