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

[mdvd]

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

[Johnnyg · Accepted solution]

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...

[Sonic]

@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]

@mdvd 

You can refer this video to resolve your issue

Also request you to please subscribe this channel

https://youtu.be/HFghBAYX-oQ

[luuminhvuong93]

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 ?