Answered

Power Automate Cloud Flow using DAX query

(0) Share

Report

Posted on by JWessel

Hello,

I have a PowerBI visual where the source is PostgreSql DB, on AWS, via an ODBC connection (gateway also). The visual in BI populates with data. I used the Optimizer to get the DAX query and use that in my first step after setting Recurrence. The step appears to run but doesn't return any data.

Outputs shows code of 200 with results body as follows:

{

"results": [

{}

]

}

What I'm not understanding is why Power BI produces results but not Power Automate. I've attached the DAX Query below as well.

// DAX Query

DEFINE

VAR __DS0Core =

SUMMARIZE(

'Abandoned Cases',

'Abandoned Cases'[Case],

'Abandoned Cases'[Days Old],

'Abandoned Cases'[Status],

'Abandoned Cases'[Request Date],

'Abandoned Cases'[Conference]

)

VAR __DS0PrimaryWindowed =

TOPN(

501,

__DS0Core,

'Abandoned Cases'[Conference],

'Abandoned Cases'[Days Old],

'Abandoned Cases'[Case],

'Abandoned Cases'[Status],

'Abandoned Cases'[Request Date],

)

EVALUATE

__DS0PrimaryWindowed

ORDER BY

'Abandoned Cases'[Conference],

'Abandoned Cases'[Days Old] DESC,

'Abandoned Cases'[Case],

'Abandoned Cases'[Status],

'Abandoned Cases'[Request Date]

Any thoughts on what my issue could be?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report
What happens when you run this query instead?

EVALUATE SUMMARIZE( 'Abandoned Cases', [Case], [Days Old], [Status], [Request Date], [Conference] )

Is "Days Old" a column or a measure?

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report

"Days Old" is a column. My apologies, but I'm not sure where I should "run" the query you listed from. The query I provided above is just copied from the Optimize/Performance Analyzer in Power BI project. Are you suggesting that I somehow replace what is below with that? How exactly would I do that?
EVALUATE
__DS0PrimaryWindowed

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report

I modified the Evaluate _DS0PrimaryWindowed to replace that with your Evaluate and I get the same results which is no data.

Was this reply helpful? Yes No
lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

Replace your entire query text with my version.

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report

Ibendlin. Thanks much !! That appears to get a data table in my flow. I am very appreciative.

Was this reply helpful? Yes No