Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Getting an ODBC Connection Created

Hi Everyone, 

 

I am just starting a project where I will be implementing Power BI for an organization which is a franchise & has many branches but need some help & advice on the first steps which involve creating an ODBC link to gain access to the live data. 

 

To give some important context, the software providers to the organization recently announced that they were also going to start implementing Power BI for their clients (even though they failed at trying to make their own BI tool), and are therefore a competitor to me. 

The problem with this is that they are heavily involved in providing me access to the credit union's data. 

So what do I need help & expertise with? 

 

I need to know what exactly is required on my end to ensure I can use the ODBC link & that it can be created asap, someone told me that I need to be added as a user to the software's database & also added as a user within the software tool itself but I can't find any clear answers. I think I may need the expertise of a DBA but again, not sure. 

 

my goal is to ensure I have everything done on my side so I can push everything on them if they try & slow down the project.

 

It has been 2 weeks since my original call with the software providers so I want to send them a detailed email. Someone also told me that ODBC Connections can be created within 15 minutes, is this true? 

I am willing to pay someone a very fair hourly rate for some advice & also to maybe jump on some calls with them.

1 REPLY 1
lbendlin
Super User
Super User

To create an ODBC connection you need to have the ODBC driver for their data soure installed, and then you run the 

lbendlin_0-1696637391067.png

app on your PC. There you can select the desired driver and specify the name and details of the connection. Best to create a System DSN.

lbendlin_0-1696637588387.png

 

lbendlin_1-1696637625823.pnglbendlin_2-1696637669391.png

 

 

Then in Power BI all you need is to select ODBC as the conenction type, and "dsn=name"  as the data source.

lbendlin_3-1696637716850.png

 

lbendlin_4-1696637736148.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.