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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (1)

All responses (5)

Answers (1)

Verified answer

Sutherland Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sonic 6 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Powerplatform01 386 on at

Like (0)

Report
Copy link

Link copied!

@mdvd
You can refer this video to resolve your issue
Also request you to please subscribe this channel
https://youtu.be/HFghBAYX-oQ

Was this reply helpful? Yes No
luuminhvuong93 300 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
RavKobus 14 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No