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.
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.