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.
Can you please help in answering the below question so that i can guide you the best possible answer.
- Are you using power bi per user licence or Premium capacity.
-What type of data source.
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]