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