Mynda and Catalin, I was able to check one of m PCs at home, and it actually has Windows 10 and Office 2013. Updated to mot current version of PQ a...
Mynda and Catalin, So, I do realize that PQ is no longer an add-in for 2016. However, we won't have 2016 for several years. I was upgrading my c...
Mynda, I should note: I tested an .xlsx file with 46 fields and 1.04M records, but very low cardinality. Power Pivot imported that file with lit...
Mynda, I attached Word document with of the results of my testing. Hopefully I did the upload correctly. Of note, it appears the Power Query engine...
Hi Mynda, Thanks for the info, makes sense to me. I have experienced some of the heartache from direct data connections to Power Pivot. I'd love to...
Mynda, No, the raw data file closed when loading. My only thought is that pulling data from .xls* carries some .xls* "baggage", formatting or other...
Mynda, 1) Raw data is in Workbook A, then pulled into a data model in Workbook B. 2) In this case, the data in Workbook A was not in a table. ...
Mynda, In my original test it was raw data from .xlsx into Power Pivot, and then raw data from .txt into Power Pivot (2013). I stated incorrectly a...