cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MagicMads Regular Visitor
Regular Visitor

2018-06-06 12:31:48.4514|ERROR|85|PBI.Win.ProcessingError|ExceptionType:Microsoft.AnalysisServices.

Hi - Moslty my PBIRS works well - however, occaisonally I get this

 

2018-06-06 12:31:48.4514|ERROR|85|PBI.Win.ProcessingError|ExceptionType:Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException;stackTrace: at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.GetPropertyFromServer(String propName, Boolean sendNSCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.get_Database()
at Microsoft.ReportingServices.DataExtensions.AdoMdDaxConnection.GetModelMetadata(String perspectiveName, String supportedVersion)
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService);message:GetModelMetadata;| RequestID = 32d155b8-89ce-634e-c416-7a84f2d2fab5 ClientSessionID = 3e2426ce-340d-7a80-a954-44511cafe94f
2018-06-06 12:31:48.4514|ERROR|85|PBI.Win.ReportingServicesHostTrace|type:Error;message:library:Throwing Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: , Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, 'REGIONSYD\puh1id', does not have access to the 'INSIGHT Analytics' database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.GetPropertyFromServer(String propName, Boolean sendNSCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.get_Database()
at Microsoft.ReportingServices.DataExtensions.AdoMdDaxConnection.GetModelMetadata(String perspectiveName, String supportedVersion)
at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.GetModelMetadata(DataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, String modelMetadataVersion, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService)
--- End of inner exception stack trace ---;;| RequestID = 32d155b8-89ce-634e-c416-7a84f2d2fab5 ClientSessionID = 3e2426ce-340d-7a80-a954-44511cafe94f
2018-06-06 12:31:48.4514|ERROR|33|Failure in conceptualschema| RequestID = 32d155b8-89ce-634e-c416-7a84f2d2fab5 ClientSessionID = 3e2426ce-340d-7a80-a954-44511cafe94f Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, 'REGIONSYD\puh1id', does not have access to the 'INSIGHT Analytics' database, or the database does not exist.

 

From a XE-log I am running on the MSAS-server I can see login/out events for the specific user - but no other requests.

 

The user keeps trying - (three times, with the same result) and the fourth time it operates normally again.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 962 guests
Please welcome our newest community members: