Solved: Dataflow ODBC connector

dufoq3 · ‎06-20-2024

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.

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

BiAnalyst · ‎06-20-2024

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.

View solution in original post

BiAnalyst · ‎06-20-2024

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 · ‎06-25-2024

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.

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.