Forum Discussion
robarivas
9 years agoPost Patron
Large Table performance
I'm connecting to an IBM DB2 database (z/OS) via ODBC (cause I could never get the built-in connector to work). Most tables are viable. However, I cannot find a way to get the transactions table data...
Phil_Seamark
9 years agoMicrosoft Employee
Hi robarivas,
Get rid of any columns that have unique ID's and if you have a column that is Date & Time, split that into two columns in Power Query (or just drop time altogether).
Do any of those help?