Solved: How to make a oledb connection?

Anonymous · ‎03-28-2016

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

arify · ‎03-29-2016

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 🙂

arify · ‎03-28-2016

You can try OleDb.Query

Anonymous · ‎03-29-2016

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

arify · ‎03-29-2016

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

Anonymous · ‎03-29-2016

I find OLEDB connection option in the Power BI desktop, you could tell me how I make that connection?

arify · ‎03-29-2016

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 🙂

bebeto · ‎05-12-2016

My Power BI Desktop doesn´t recognize

OleDb.Query

Is it possible to create an OLEDB connection to a file?

How to make a oledb connection?