Power BI Report Server (January 2019) Oracle Database Data Source

Anonymous — Wed, 30 Jan 2019 16:03:22 GMT

Hi, I am testing with Power BI Report Server connected to Oracle Database 12c, all the components have been configured correctly but when I try to visualize content I return error, in the log I found the following, they could indicate me how I can solve.

2019-01-23 18:07:57.8126|ERROR|35|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 = '' ClientSessionID = ''
2019-01-23 18:07:57.8126|ERROR|35|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 ''.
The command failed to execute because it was unable to impersonate a Windows user identity.
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 = '' ClientSessionID = ''

Re: Power BI Report Server (January 2019) Oracle Database Data Source

rpatkar — Thu, 31 Jan 2019 14:51:46 GMT

We issued a fix yesterday that should address this issue. Please upgrade to the latest build available.

Thanks,
Rohit

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Anonymous — Tue, 05 Feb 2019 21:03:44 GMT

Greats!, it is solved.

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Anonymous — Thu, 28 Feb 2019 07:34:26 GMT

can I have a link of this upgrade? I have downloaded the same in https://powerbi.microsoft.com/en-us/report-server/ but issue is the same.

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Anonymous — Thu, 28 Feb 2019 21:57:22 GMT

You installed Oracle Developer Tools for Visual Studio?

https://www.oracle.com/technetwork/topics/dotnet/downloads/odacmsidownloadvs2017-3806459.html

topic Re: Power BI Report Server (January 2019) Oracle Database Data Source in Report Server

Power BI Report Server (January 2019) Oracle Database Data Source

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Re: Power BI Report Server (January 2019) Oracle Database Data Source

Re: Power BI Report Server (January 2019) Oracle Database Data Source