Connection has an oracle view

[Anonymous]

Hello,

I would like to know how to connect to an Oracle view with Power BI ?

Thanks in Advance

Cha

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

As far as I know, Power BI does support views.
You can refer to the following article to connect to Oracle.

Refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database 

In my test,try to connect to it by entering your server and database name as you normally would, but then expand the "Advanced Options", and drop in a query to call upon that view 
    SELECT [Field List]
    FROM dbo_viewname

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@Anonymous , is it not showing under tables ?

refer old solution if needed

https://community.powerbi.com/t5/Desktop/Could-not-load-oracle-view/m-p/528495