Easy Tech TutsHow to Connect ODBC to Power BI Desktop (Driver Setup Included) Easily 2026
By Impran M N
Plenty of data sources rely on ODBC connections, but getting Power BI talking to them requires the right driver installed first. This guide walks through installing an ODBC driver and connecting it to Power BI Desktop from start to finish. It's aimed at anyone who needs to pull data from a database or system that Power BI doesn't connect to natively.
01Understand ODBC
ODBC is a standard interface that lets applications like Power BI communicate with many different types of databases through a common driver-based approach.
02Download and install the ODBC driver
Find the correct driver for your specific data source, download it from the vendor, and install it on the machine running Power BI Desktop.
03Connect ODBC to Power BI
Use Get Data in Power BI Desktop, select the ODBC connector, and choose the data source name configured through your ODBC driver setup.
04Troubleshoot common issues
If the connection fails, check that the driver architecture matches Power BI's, either 32-bit or 64-bit, and confirm the data source name is configured correctly in the ODBC Administrator.
05Optimize your data visualization
Once connected, shape the imported data in Power Query before building visuals, filtering out anything unnecessary for cleaner reports.
Frequently asked questions
Where do I configure an ODBC data source name before connecting to Power BI?
This is done through the Windows ODBC Data Source Administrator tool, where you set up a named connection using the installed driver before Power BI can reference it.
Why does Power BI say it can't find my ODBC data source?
This is often caused by a mismatch between the 32-bit and 64-bit versions of the driver and Power BI, or the data source not being configured in the right ODBC Administrator panel.
Can multiple people use the same ODBC connection in a shared report?
Each user typically needs the same driver and data source name configured on their own machine, since ODBC connections are set up locally rather than shared automatically.
Is ODBC the best option if a native Power BI connector already exists for my source?
A native connector is usually preferable when available, since ODBC is generally reserved for sources without dedicated Power BI support.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
