Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to create a power automate flow to count number of records in a table after a refresh

(0) ShareShare
ReportReport
Posted on by 352
Hello. 
 
My Power BI Refresh is having intermittent issues, whereby its not always returning the full data set. 
How can i create a power automate flow to query the dataset to do a count of the records in a table?
 
I also have the same issue with a DataFlow, can i use power automate to run query against a dataflow to do a count of records in a given table after a refresh?
 
Thanks 
  • Vstar19 Profile Picture
    Vstar19 352 on at
    How to create a power automate flow to count number of records in a table after a refresh
    hello. 
    unfortunatley not. We dont have that value stored in the flow anywhere
  • abm abm Profile Picture
    abm abm 32,265 on at
    How to create a power automate flow to count number of records in a table after a refresh
    Hi
     
    Did your try run a DAX Query against your dataset?
     
    ROW("RecordCount", COUNTROWS('YourTableName'))

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard