Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Arsenij
Regular Visitor

August 2017 Power BI RS Redshift connection problem

Thank you MS Power BI team for adding other data sources in the new preview release.

 

I have successfully saved am Import Data Redshift based report via Power BI Desktop Optimized for RS (August 2017) and it shows data on the web.

However, I got a problem with a DirectQuery Redshift based report. Although it was saved successfully, on the web it is unable to load a model. For the id that is shown in an error message I found the following in a server log:

 

2017-08-31 14:14:57.4898|INFO|40|Received request POST /api/explore/reports/d31c98ad-860d-44e9-abd4-0e04cd6b17ff/conceptualschema| RequestID = 892b9aa3-ea5f-3115-b343-20eb7e6bea45 ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 
2017-08-31 14:14:57.5500|ERROR|8|PBI.Win.ProcessingError|ExceptionType:Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException;stackTrace:   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, IDictionary requestProperties)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors, IDictionary requestProperties)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors, AdomdPropertyCollection requestProperties)
   at Microsoft.ReportingServices.DataExtensions.DefaultAdoMdConnectionFactory.GetSchemaDataSet(IDbConnection connection, String schemaName, IList`1 restrictionList)
   at Microsoft.ReportingServices.DataExtensions.AdoMdDaxConnection.InternalGetModelMetadata(String catalogName, String perspectiveName, String supportedVersion)
   at Microsoft.ReportingServices.DataExtensions.AdomdExceptionHandler.Execute[T](String connectionString, Func`1 func)
   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 = 892b9aa3-ea5f-3115-b343-20eb7e6bea45 ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 
2017-08-31 14:14:57.5500|ERROR|8|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: A connection could not be made to the data source with the Name of '49237c7a-3fcb-429a-8257-4b8bf5bef3eb'.
COM error: System.Configuration; An error occurred loading a configuration file: The parameter 'exePath' is invalid.
Parameter name: exePath.
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, String requestNamespace, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, IDictionary requestProperties)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, IDictionary adomdRestrictions, Boolean throwOnInlineErrors, IDictionary requestProperties)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet(String schemaName, String schemaNamespace, AdomdRestrictionCollection restrictions, Boolean throwOnInlineErrors, AdomdPropertyCollection requestProperties)
   at Microsoft.ReportingServices.DataExtensions.DefaultAdoMdConnectionFactory.GetSchemaDataSet(IDbConnection connection, String schemaName, IList`1 restrictionList)
   at Microsoft.ReportingServices.DataExtensions.AdoMdDaxConnection.InternalGetModelMetadata(String catalogName, String perspectiveName, String supportedVersion)
   at Microsoft.ReportingServices.DataExtensions.AdomdExceptionHandler.Execute[T](String connectionString, Func`1 func)
   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 = 892b9aa3-ea5f-3115-b343-20eb7e6bea45 ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 
2017-08-31 14:14:57.5500|ERROR|11|Failure in conceptualschema| RequestID = 892b9aa3-ea5f-3115-b343-20eb7e6bea45 ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 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: A connection could not be made to the data source with the Name of '49237c7a-3fcb-429a-8257-4b8bf5bef3eb'.
COM error: System.Configuration; An error occurred loading a configuration file: The parameter 'exePath' is invalid.
Parameter name: exePath.
2017-08-31 14:14:57.5500|INFO|19|Sending response. Response code KYIV\Arsenij_Kroptya 200, Elapsed time 0:00:00,0648533| RequestID = 892b9aa3-ea5f-3115-b343-20eb7e6bea45 ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 
2017-08-31 14:14:58.0513|INFO|44|Received request POST /api/explore/reports/d31c98ad-860d-44e9-abd4-0e04cd6b17ff/conceptualschema| RequestID = b7bbcb9f-9acf-203f-3402-22404568f05a ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 
2017-08-31 14:14:58.0919|ERROR|8|Failure in conceptualschema| RequestID = b7bbcb9f-9acf-203f-3402-22404568f05a ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 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: A connection could not be made to the data source with the Name of '49237c7a-3fcb-429a-8257-4b8bf5bef3eb'.
COM error: System.Configuration; An error occurred loading a configuration file: The parameter 'exePath' is invalid.
Parameter name: exePath.
2017-08-31 14:14:58.1245|INFO|24|Sending response. Response code KYIV\Arsenij_Kroptya 200, Elapsed time 0:00:00,0730723| RequestID = b7bbcb9f-9acf-203f-3402-22404568f05a ClientSessionID = 25135019-4d07-0889-1dbf-135cc930242d 

Please, advise what has to be configured in order to use connections to Redshift.

 

 

1 REPLY 1
Arsenij
Regular Visitor

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors