Notifications
Announcements
Hi Team,
working on flow from power bi.
I want to select 3 fields from power bi data. so after compose added select components,
however, it is adding FOR EACH automatically.
i am not understanding why its adding it.
Hey @Narendra90
The Power BI Data must be an array thats why its creating an apply to each. I have two three things in my mind to suggest to you. First one is, initialize an array variable outside this apply to each. Inside the apply to each use append to array and pass the body of select in it. And then use this array variable outside the apply to each.
I hope this helps. 🙂
Hi Sundeep Malik,
Thanks you very much. However it only selecting first 1000 records.
I have around 5000 rows. i need to filter only "Active" from project status column.
would you please guide me on this.
@Narendra90
I have no idea why its only showing 1000 records.
Can you do one thing, without that append to array, is the apply to each still running 1000 times or its running for more records?
Probably its a limitation of Power Automate to read 1000 lines from Power BI. Read in some other posts. No idea tbh.
Found this alternate solution instead, where the person has suggested to make a table from all the data. Not sure it will work or not, but you should give it a go.
https://community.powerbi.com/t5/Desktop/Power-Automate-export-1000-rows-only/td-p/1811090
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 378 Super User 2025 Season 2
David_MA 305 Super User 2025 Season 2
Expiscornovus 155 Most Valuable Professional
