Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
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.
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.
@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
ODBC is notoriously slow.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |