Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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. 

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! 

Need Help
Show and Tell
  • Smalfly's avatar
    Smalfly
    3 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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? 

       

  • Smalfly's avatar
    Smalfly
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    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.