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
Community Support
Community Support

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

4 REPLIES 4
Johnnyg
Community Support
Community Support

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.
Sonic
Frequent Visitor

@mdvd , do you mind sharing screenshots of your process to convert the file to cvs, what you did is exactly what im trying to do.

Please share, thanx

Powerplatform01
Post Patron
Post Patron

@mdvd 

You can refer this video to resolve your issue

Also request you to please subscribe this channel

https://youtu.be/HFghBAYX-oQ

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 ?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,198)