Bypassing ODBC to connect to SQL Server

[Anonymous]

Hi All, 

I am new to PBI community. 

Currently we have connected PBI with PLEX (MES - Manufacturing Execution System) via ODBC to access SQL database. This process makes PBI horribly slow. 

Can anyone help me understand if ther is a way to bypass ODBC so that I can connect directly with SQL Server to pull data? 

Thank you for all your help in advance! 

[Smalfly · Accepted solution]

Hi @Anonymous ,

you can connect to a sql server environment from Power BI:

What you can do, is re-create 1 table manually. Then go to advanced editor in your 'Transform data' view. You can then copy the first part of your query, and replace the odbc part by the copied text in the advanced editors of all tables that you now access using ODBC.

[amitchandak]

@Anonymous , Power BI has a SQL server connector, are you not using that?

[Anonymous]

Hi Amit, 

For some reason my IT point of contact keeps insisting on connecting via ODBC. Are you saying all I need to do is change the source the data source to bypass ODBC?