Dump the results of a DAX query to CSV using PowerShell
I recently got an interesting question: someone inside Microsoft wanted to get a data dump from a big Tubular model that is used internally. They wanted a special table using columns and calculated fields from several tables. So we want to use a DAX query. The result would count more that 1.5 million rows so using Excel was out of the question.
Read more...Tags: amo, script, powershell, tabular