An error occurred while loading the model. Failed to open the MSOLAP connection
Hi, We have an ScaleOUT deployment balanced by Citrix. After start PowerBI windows service works fine for about 2-4 hours. For different reports different users receive error: "An unexpected error occurred. Please try again later. Please try again later or contact support. If you contact support, please provide these details. We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.: Request ID: 78b76716-b0f4-2ef2-92b6-59865bf41959 Time: Tue Feb 22 Service version: /powerbi/libs" In PowerBI log for that error: " Failure in conceptualschema catalogObjectId=46d80967-430e-4f41-a5fd-d965ce64f404| RequestID = 78b76716-b0f4-2ef2-92b6-59865bf41959 ClientSessionID = 7b475ef1-f3fa-3977-fa30-6ad9f34f4064 Microsoft.PowerBI.ReportingServicesHost.CannotRetrieveModelException: An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to open the MSOLAP connection. ---> MsolapWrapper.MsolapWrapperException: Could not initialize connection at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message) at MsolapWrapper.Connection.Open() at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() --- End of inner exception stack trace --- at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() at Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() at Microsoft.PowerBI.ReportServer.ExploreHost.WindowsUserIdentityConnectionImpersonator.<ExecuteInContextAsync>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.<OpenAsync>d__8.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException(Task task) at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent) --- End of inner exception stack trace --- at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent) at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.<>c__DisplayClass10_1.<GetModelMetadata>b__1(ExploreBaseEvent timedEvent) at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.<>c__DisplayClass4_0`1.<RunInActivity>b__0(ExploreBaseEvent activity) at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity(String activityName, Action`1 action) at Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity[T](String activityName, Func`2 action) at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetModelMetadata(ModelMetadataRequest request) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelCSDL(String id, String maxModelMetadataVersion, IASConnectionInfo& asConnectionInfo) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.<>c__DisplayClass41_0.<GetOrAddModel>b__0() at System.Lazy`1.CreateValue() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Lazy`1.get_Value() at Microsoft.PowerBI.ReportServer.ExploreHost.RSModelCache.GetOrAddModel(ModelKey key, Func`1 modelInfoFunc) at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.EnsureSession(String modelId) at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>b__9_0() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ExploreHost.ExploreClientHandlerBaseFlow.<RunAsync>d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ExploreHost.ExploreClient.<GetClientConceptualSchemaAsync>d__13.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.ExploreHost.RSExploreHost.<GetConceptualSchemaAsync>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportServer.WebApi.PbiApi.PbiApiController.<GetConceptualSchemaAsync>d__25.MoveNext() " In executionlog3 for that requestID i see: status InstanceName ItemPath UserName ExecutionId RequestType Format Parameters ItemAction TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount AdditionalInfo rsInternalError PBI1\PBIRS /rep/rep/report domain\username 78b76716-b0f4-2ef2-92b6-59865bf41959 Interactive PBIX NULL ConceptualSchema 2024-02-22 14:32:32.460 2024-02-22 14:32:32.600 0 0 0 Cache rsInternalError 0 0 NULL That model is inside internal PBI SSAS. I receive that error few times a day. Could any one say what have i to check? We have last update for PBI server. I tried to change ModelExpirationMinutes from 60 to 120 and tried change to 5. At the moment we have 60 Yesterday we changed session persistence on citrix and after that faces that we have that error message rather rare. But issue is not fully solved by that change. Previous week i tried to restart PBI service every hour by task scheduler and zero such errors faced.
"An error has occured" when clicking on report (On Prem)
Halle everyone, for some weeks now everytime i click on a report on our reportserver i get this: There is no more text to the error. And the only thing im doing is clicking on the report. i tried updating to the latest version (version: 15.0.1111.115) but it didnt help. With PowerBI Desktop (January 2023) i cannot open nor save PBI Files on the Server. Same issue: Thank you in advance for any advice. KR GordanOn-Prem vs. Cloud?
Hi, We are just about to embark on our PowerBI journey after doing some preliminary POC demos late last year. Since we already use SSRS quite a bit, one question we are trying to get clarity on is what are the main differences between deploying PowerBI reports on-prem vs pushing them to the cloud (costs aside)? Are there any key functionality drawbacks for either option? Is on-prem just a 'temporary' solution to use as a stepping stone to get us into the cloud as an end-game? - edit 2018/01/23: Also, can we run Report Server without purchasing Power BI Premium? I understand that with Premium the Report Server in included, but I am assuming we can licence Report Server on it's own (if we don't also get it included with either our SSRS or other corporate Microsoft licencing)? Are BI Pro licences for content producers sufficient (with others that will only be consumers having just 'regular' Power BI licences) -/edit 2018/01/23 Any feedback is welcome and appreciated! Thank you!
RLS In PowerBi On Prem
Hello, Attempting to Move a report I made onto PowerBi on Prem as we have ent sql licences. In my report I use RLS which works fine when published to PowerBi Website but on Prem I cant see any menu option for adding users to the role etc. My connection is to a SQL server and the method is Import (same as on the website). Does On Prem not support RLS in PowerBi? If so thats shockingly poor, hoping I am wrong on this. Mark
Getting an access token to an on-premise installation of Power BI Reporting Server
I am trying to move reports from a SSRS installation to Power BI. I am able to get the reports moved over to the Power BI server; however, the Data Sources are not completely migrating over. This is acceptable if the Data Sources can be updated through the Api. There a small number of Reports to move and all of the reports will use a even smaller handful of Shared DataSources. During the migration the Data Source name is kept but the credential information in it needs to be updated. The hope is through V2 Api I can sign in and update these Data Sources with the correct credentials. I do notice that during my migration that the name of the Shared Data Source is retained in the migration. At the end of the day, I have to hand this migration tool off to put the reports into production. This may not be the best place for this question, but I had to start somewhere.Power BI Embedded and Stored Procedure parameter passing
Hello everyone, this is my first post, so I hope I am posting in the correct part of the forum. I have been searching for an answer for this question but so far I haven't found an answer. At the moment my company is evaluating the possibility of changing some solutions to Power BI. We access most of our information through Stored Procedures from SQL Server, which receive parameters in order to give dynamic results, this is required because we have a KPI engine inside our database which calculates them on-the-fly. At the moment we use Tableau embedded inside our Web Application, but Tableau has big performance issues with Stored Procedures, and we were looking at Power BI if it could be the alternative that could solve our performance issues, but from what I could find, at the moment Power BI is not able to receive parameters via URL and pass them to a Stored Procedure, correct? Also we require it to be On-Premises.
