cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mdvd
New Member

Power BI -> Export to Excel -> email Excel to user

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?

 

snap.PNG

 

--

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Johnnyg
Microsoft
Microsoft

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

Johnnyg_0-1621168493362.png
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...

 

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Johnnyg
Microsoft
Microsoft

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

Johnnyg_0-1621168493362.png
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...

 

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (2,156)