Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Connection has an oracle view

Hello,

 

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

 

Thanks in Advance

 

Cha

  • 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

2 Replies