Reply
Frequent Visitor
Posts: 11
Registered: ‎10-19-2017
Accepted Solution

ODBC vs SQL

Hello , 

 

  I have SQL database and our ERP connects to SQL using ODBC. I can Get Data to Power BI both ways - connecting SQL server database and ODBC. Which way should i prefer ?


Accepted Solutions
Highlighted
Advisor
Posts: 309
Registered: ‎01-16-2018

Re: ODBC vs SQL

[ Edited ]

@vejas,

 

ODBC is slower. But is very comfortable when you have a lot of people who do different reporting and creation of reports in Power BI. And only admin manage this connection. If IP of ERP has been changed from production to testing or developement or backup IP then you change it in only one place. 

View solution in original post


All Replies
Super User
Posts: 10,775
Registered: ‎07-11-2015

Re: ODBC vs SQL

ODBC is notoriously slow.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Moderator
Posts: 10,202
Registered: ‎03-10-2016

Re: ODBC vs SQL

@vejas,

I would recommend you use the built-in SQL Server connector in Power BI Desktop, with this connector, you have two modes(Import or Directquery) to choose. 

DirectQuery lets you build visualizations over very large datasets, you can choose it based on your business requirement.



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advisor
Posts: 309
Registered: ‎01-16-2018

Re: ODBC vs SQL

[ Edited ]

@vejas,

 

ODBC is slower. But is very comfortable when you have a lot of people who do different reporting and creation of reports in Power BI. And only admin manage this connection. If IP of ERP has been changed from production to testing or developement or backup IP then you change it in only one place.