Limited records are getting exported in excel

[PavaniD]

Hello

I published my report which has record count = 669700.

When exporting into excel its giving me only 150000 records.

Any solutions on how to resolve this?

Thanks in advance.

[v-jialongy-msft]

Hi @PavaniD 

Unfortunately, you can only export up to 150,000 rows of data, which is a known limitation:
Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

[_AAndrade]

Hi @PavaniD,

Instead of export your report to excel you can connect the data set to excel and that way you will get all rows.

[PavaniD]

There are many tables so this approach doesnt work.