Forum Discussion
Solved
Best Practice for Exporting Large Data Tables?
Hey all, I have a table I created that produces 3.6M records that I need to export, I've been trying all day but PBI is randomly dropping data and for the life of me I cannot determine why. I've ...
Got a bit of a work around:
- Connect table to DaxStudio
- Evaluate whole table
- Export whole table via text document
- Import into Access
- Filter as desired and export
I cannot because the data exceeds Excel's max limit of records, the table I am attempting to export w.out copying and pasting is 3.4m records.
Got a bit of a work around:
- Connect table to DaxStudio
- Evaluate whole table
- Export whole table via text document
- Import into Access
- Filter as desired and export