Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
"DirectQuery data connections are not currently supported."
https://powerbi.microsoft.com/en-us/documentation/reportserver-whats-new/#august-2017-preview