Export items more than 1,50,000

[Bharat7]

Hi ,

I have a power BI matrix visual where I can export 1,50,000 rows to excel. But my requirement is to export more than 1,50,000.
Is there a way to achieve that?

Thanks in Advance!!!!

@amitchandak @Greg_Deckler  @lbendlin @parry2k 

[parry2k]

@Bharat7 I think you have the possibility to embed paginates reports in the web app, and it was introduced recently.

Embed a paginated report in Power BI embedded analytics | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[v-xiaoyan-msft · Accepted solution]

Hi @Bharat7 ,

To my knowledge ,  you can not export more than 1,50,000 rows to excel directly in Power BI, it is by design.

You may vote the idea  and comment there to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Or You can follow this link below to see if it will meet your needs.

Exporting a large number of rows from Power BI to Excel or CSV 

Hope it helps,

Community Support Team _ Caitlyn

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

[parry2k]

@Bharat7 I would recommend using Power BI paginated report, if it is a one-time stuff then you can export using DAX studio.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Bharat7]

Hi @parry2k , Thanks for the reply. I can try paginated but in my case I embedded the report in web app. So paginated may not work