Forum Discussion

dufoq3's avatar
dufoq3
Community Champion
2 years ago
Solved

Dataflow ODBC connector

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.

Need Help
  • BiAnalyst's avatar
    BiAnalyst
    2 years ago

    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.

2 Replies

  • BiAnalyst's avatar
    BiAnalyst
    Resolver I
    2 years ago

    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's avatar
      dufoq3
      Community Champion
      2 years ago

      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.