ODBC Connections In Power BI

Anonymous · ‎04-10-2019

Hello

I come from a SQL Server background and just moved to a company that is using an ODBC to connect NetSuite to Power BI. Personally, I see this as an extremely cumbersome process and know that we can benefit greatly from moving away from this process by adopting a data warehouse to act as a replica of the transactional database that NetSuite is.

I'm looking for any suggestions, recommendations, comments, or concerns from people who have experience using the ODBC connection.

Thanks

Greg_Deckler · ‎04-10-2019

Well ODBC is generally pretty slow. You might have better luck with an OData connection through CData or Skyvia.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...