I use Devart ODBC drivers in order to create a connection with Power BI https://www.devart.com/odbc/powerbi/
How to connect Power BI to ODBC data source and access data in 3 steps:
- Install the driver and configure an ODBC data source. Start Power BI and choose Get Data > Other > ODBC.
- Choose the DSN that you configured for the ODBC Driver and enter your credentials in the next step.
- Now Power BI database connection is established: you can load a table for business intelligence reporting.