Log In
Register
Home
January 25, 2021
Offline
I have over 5,000,000 records i want to download so i can put in excel or csv and share data. i have DX studio and it downlaoded one tab of data but only as much that can fit on one tab. Is there a fairly quick way to export this data? I am not a code writting expert i am just learning. Thnak you.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Chad,
Instead of excel, use Power BI (which contains Power Query and Power Pivot tools)
If you install R language in Power BI, you can use a very simple R Script to export a query to csv:
The query step looks like this:
RScript= R.Execute("write.csv(dataset,""e:\\test.csv"")",[dataset=#"Changed Type"])
Or, whenever you want to save to xlsx, even to a defined table, you can use:
write.xlsx(dataset,"e:\\test.xlsx", asTable = TRUE)
asTable = FALSE will save to xlsx without creating a defined table.
In your case, write.csv is what you need.
1 Guest(s)
