Forum Discussion

cheezee's avatar
cheezee
Regular Visitor
8 years ago
Solved

Connecting to ODBC Datasource using SQL Statement

Hello guys,   I'm trying to connect to an Oracle database (that has over 300,000 objects within a certain schema) by using an ODBC connector. Reason being, the Oracle database is hosted in a UNIX e...
  • Anonymous's avatar
    Anonymous
    8 years ago

    cheezee,

    Option1:

    Write SQL statement in Power BI Desktop.


    Option2:

    Add a blank query in Power BI Desktop, paste the following code into Advanced Editor of the blank query.

    let
    Source = Odbc.Query("dsn=yourdsn", "Select * from yourtable")
in
    Source




    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

cheezee,

Option1:

Write SQL statement in Power BI Desktop.


Option2:

Add a blank query in Power BI Desktop, paste the following code into Advanced Editor of the blank query.

let
    Source = Odbc.Query("dsn=yourdsn", "Select * from yourtable")
in
    Source




Regards,
Lydia

  • cheezee's avatar
    cheezee
    Regular Visitor
    8 years ago

    Thanks Lydia,

     

    I'll try this out and see how it goes. I believe this should solve my problem. :smileyhappy: