PowerBI Shared reports

[fgasimzade2]

Hello Everyone,

When we share a report we get an error:

"There is no gateway to access the data source Oracle"

The data source works fine from the desktop application itself, the error happens only when report is shared with other users through cloud

As far as I understand, our data source (Oracle database) must be accessible from cloud(internet) in order this report to be accessible? Am I correct?

[fgasimzade2]

Hello @SanikaT ,

Thank you for your clarification. How this gateway should be configured and where? In the report itself?

[SanikaT]

Hi,

For this, you may need to make the Oracle database accessible from the cloud. This may involve configuring network security groups or firewalls to allow traffic from the cloud environment to the Oracle database.

The gateway should be configured outside of the report itself, typically in the cloud service or platform that you are using to share the report.

It's also important to ensure that the necessary drivers and software components are installed on the cloud environment to enable the connection to the Oracle database. You may want to check with your IT department or the cloud service provider for guidance on how to configure access to your Oracle database from the cloud environment.

Thanks,

[fgasimzade2]

Hello @SanikaT 

I probably put it wrong saying "cloud". I was reffering to Office 365, when PowerBi report is shared

[SanikaT]

Hello,

Yes, you are correct.

In order for your report to be accessible to other users through the cloud, your Oracle database must be accessible from the internet.

Thanks,