You’re offline. This is a read only version of the page.
Hi all!
Since april we can use Flow within PowerBI.
I created a flow to export PBI data to CSV, it works.. But it only export the first 1000 rows?
So first question, how can I increase the number of rows?
--
But what I really want to do is this: (A)
- export data to a Excel (not csv) (temp file?)
- than email this file to the user who triggered the flow
- delete the temp file
Thanks for your feedback!
Regards
M
You can start building a solution similar to mym that I have described in my post. It creates a xlsx file from PowerBI in seconds, then you can attach that to an e-mail for example.
Scheduled export from Power BI dataset to Excel – Rafal Kobus site (wordpress.com)
I can no longer access the Video on Youtube, it has been flagged due to copyrights by someone
Could u pls share the solution again to this issue ?
You can refer this video to resolve your issue
Also request you to please subscribe this channel
Hello mdvd,
I saw your post in BI community as well. So I do some research from both BI and Flow end:
1. Flow end: No data limits for BI report data. There's only connector throttling 100API Call/1 min / connection
Doc reference: https://docs.microsoft.com/en-us/connectors/powerbi/#triggers
2. BI End : I only find 'The default data point limits by visual type is 1,000' mentioned in BI Official Doc
Doc reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points#power-bi-visuals
In addition, I found the same ask and code suggestion from BI Community which could help on your question:
https://community.powerbi.com/t5/Power-Query/Api-limit-of-1000-records-getting-the-next-1000-records-and-so/m-p/1173541
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (