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)

Sort by

Verified answer

lbendlin 8,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

"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
Copy link

Link copied!

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,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Replace your entire query text with my version.

Was this reply helpful? Yes No
JWessel on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No