I am having this same issue. It sounds like you've confirmed it will not truncate the data at least up to 10,000 records, but how do we know for sure when receiving the error. We're supposed to be able to download 150,000 records. I am unsure as to whether or not I have a complete data set when using this feature.
Every release of Power BI seems to result in more bugs. These new bugs every month waste so much time. It's really frustrating.
Yes, apparently. Also it's still is doing that thing where it removes duplicate columns, well different headers but the same content - not a good design but yes I really intended to put a duplicate column. PowerBI removes the twin column and leaves only one.