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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
fgasimzade2
Regular Visitor

PowerBI Shared reports

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?

4 REPLIES 4
fgasimzade2
Regular Visitor

Hello @SanikaT ,

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

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,

Hello @SanikaT 

 

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

SanikaT
Helper I
Helper I

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,

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.