Publishing Oracle data to Power BI without gaining direct access to the SQL database

Hi, RenateBK 

Thanks for your quick response !

When we use the fixed SQL statements, Power BI will send a SQL query statement by default, and will not send other queries to Oracle.And all the operations you do in Power Query will not cause query folding (that is, no statements other than the default query statement will be sent to the underlying data source).

For this import mode, only when the data is refreshed, you need to access the Oracle data source and send this default query to query the data. All other operations and operations are completed by using Power BI's own built-in engine after obtaining the data.

Secondly, you need to enter the credentials of the data source, that is, the account number and password of your data source, if you connect to the data source for Desktop or Service. However, you can open permissions separately for opening tables that require permissions according to your privacy.

And if you want to connect to the local data source on Power BI Service, you need to download the local data gateway and add the corresponding data source credentials in the local data gateway before you can refresh the plan. And the logic is the same as before, only when refreshing will a fixed SQL statement be sent to the data source, and no other query statements will be sent.

If your IT can't provide the account number, you can try to let IT connect to manage the connection and publication of the data source, then you can use Power BI Desktop to connect to the dataset that has been published on Power BI Service and is configured to be refreshed, and then develop the report.

For more information, you can refer to :

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly