Dataflow ODBC connector

[dufoq3]

Hi, I'm currently using ODBC connector on my PC to download company data.

Is there any way to create this type of connection in Dataflow please? I've tried several strings, but without luck.

Dataflow

Thank you in advance.

[BiAnalyst · Accepted solution]

I think all you need is to put ion "DSN =  VF19SK" in your connection string You will have to install Power Bi Gateway (not the personal mode) and setup your connections. I am connecting dataflows with simple DSN= datasource name from odbc setup and able to connect.

[dufoq3]

Hi @BiAnalyst, yes it works that way but I had to setup ODBC Data Sources 64 bit and use System DSN instead of User DSN. It works with gateway but i thought that there is also direct way without gateway.