Forum Discussion
Dates coming in as Datetime
Thank you v-fengyz-msft
Would you happen to know which of the 3 methods gives the overall best experience: ODBC, Microsoft driver, or IBM driver? Is there somewhere one could look to learn about the differences that exist, if any, amongst these three? I'm particularly interested in knowing which option does the most Query Folding. At a minimum I'd love to know about the differences between ODBC and the Microsoft driver since I've never been able to successfully connect using the IBM driver anyway.
Sorry, there are no official doucuments on these drivers to clarify the difference.
In my experience, in Power BI Desktop, I guess IBM driver should be .NET oledb driver which produced by IBM. Microsoft driver represents Microsoft OLE DB Provider for DB2.
From performance perspective, to extract big data using these drivers, in general the order of speed is: ODBC<IBM<Microsoft OLE DB Provider for DB2(fastest) when ignore other potential impact(e.g. network, I/O, memory..).
However, In Power BI Desktop, in general we develop the report using small data and write the data into cache so we don't need to be afraid of the performance. Just select which works properly.
Regards,
Pirlo Zhang