Forum Discussion
Bypassing ODBC to connect to SQL Server
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. ...
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.
Smalfly
Responsive Resident
Responsive ResidentHi 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.