Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How to make a oledb connection?


I'm looking for a way to make a connection oledb however only against odbc option

  • arify's avatar
    arify
    10 years ago

    In the Other (Outras), at the bottom there's a "Blank Query" option, click that one.

     

    And then, when you have the formula bar, type:

    = OleDb.Query

    It'll show a small help about how you can use that function

     

    You can use it like this:

     

    = OleDb.Query("your connection string", "your query")

     

    You need to find out what connection string & query you need to type in :)

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I'm finding this option in Power Bi Desktop where exactly against this means of connection with my bank?

      • arify's avatar
        arify
        Microsoft Employee

        Hi vitexo87, sorry, I couldn't understand what you're asking. Can you give me an example?