Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |