Forum Discussion

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
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 :)

Microsoft Employee

10 years ago

You can try OleDb.Query

Anonymous

Not applicable

10 years ago

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

arify
Microsoft Employee
10 years ago
Hi vitexo87, sorry, I couldn't understand what you're asking. Can you give me an example?
- Anonymous
  Not applicable
  10 years ago
  I find OLEDB connection option in the Power BI desktop, you could tell me how I make that connection?
  - arify
    Microsoft Employee
    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 :)