DAX for selecting all of the columns and data within a table

[ClemFandango]

Hi all,

I am hoping someone can help? I have a bit of a DAX problem (hey who doesn’t)…

I have quite a complicated Power Automate Flow that takes the output from a PBI query, saves it into sharepoint by splitting and joining multiple files, which allows me to automate an extract of 100,000+ rows into CSV.

My flow works fine, except for the DAX within the ‘Run a query against a dataset’ flow. All I want to do is export the contents of the table ‘Help’. The DAX in my examples work on columns that contain numbers, but it appears to fail if I add a column that contains a String like I have in 'Help’ [Test4], 'Help’ [Test5] 'Help’ [Test6]. If i add 'Help’ [Test3] (which is numeric) to the code below it will work.

I would like to use DAX to select all the columns in my table (about 35+)

// DAX Query
DEFINE
  VAR __DS0FilterTable = 
// Removes repeat headers
  FILTER(KEEPFILTERS(VALUES('Help’[Index])), and('Help’ [Index] >= @{variables('MinRows')}, 'Help’ [Index] <= @{variables('IncrRows')}))

// Export content of table 
VAR __DS0Core = 
CALCULATETABLE(
    SUMMARIZECOLUMNS(
	  'Help’[File.Name],
	  'Help’ [Index],
	  'Help’ [Test1],
	  'Help’ [Test2]),
			__DS0FilterTable
)

EVALUATE
	__DS0Core

ORDER BY
	‘Help’[Index]

Eternally grateful for any help!

[lbendlin]

Your sample code uses funny single quotes.