Forum Discussion
How to make a oledb connection?
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 :)
I'm finding this option in Power Bi Desktop where exactly against this means of connection with my bank?
Hi vitexo87, sorry, I couldn't understand what you're asking. Can you give me an example?
I find OLEDB connection option in the Power BI desktop, you could tell me how I make that connection?
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 :)
My Power BI Desktop doesn´t recognize
OleDb.Query
Is it possible to create an OLEDB connection to a file?
