Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Power Automate Cloud F...
Power Automate - Building Flows
Answered

Power Automate Cloud Flow using DAX query

(0) ShareShare
ReportReport
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.

JWessel_0-1704381238463.png

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],
1,
'Abandoned Cases'[Days Old],
0,
'Abandoned Cases'[Case],
1,
'Abandoned Cases'[Status],
1,
'Abandoned Cases'[Request Date],
1
)
 
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?

  • JWessel Profile Picture
    JWessel on at
    Re: Power Automate Cloud Flow using DAX query

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

  • lbendlin Profile Picture
    lbendlin 7,943 Super User 2025 Season 1 on at
    Re: Power Automate Cloud Flow using DAX query
    Replace your entire query text with my version.
  • JWessel Profile Picture
    JWessel on at
    Re: Power Automate Cloud Flow using DAX query

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

  • JWessel Profile Picture
    JWessel on at
    Re: Power Automate Cloud Flow using DAX query

    "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
  • Verified answer
    lbendlin Profile Picture
    lbendlin 7,943 Super User 2025 Season 1 on at
    Re: Power Automate Cloud Flow using DAX query

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans