Forum Discussion

fgasimzade2's avatar
fgasimzade2
Regular Visitor
3 years ago

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?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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,

  • fgasimzade2's avatar
    fgasimzade2
    Regular Visitor
    3 years ago

    Hello Anonymous ,

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        fgasimzade2
        Regular Visitor
        3 years ago

        Hello Anonymous 

         

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