Unable to export data from visual on PBI server

[Anonymous]

I'm having an error when trying to export a table from a reporte published. This table has a sparkline feature and it might have more than 150,000 with no filters, the problem is that even when filtered the table won't export 

it pop-up this error

And if I try to export same visual without filters (more than 150,000 rows) in Power BI Desktop, there is no error 

[v-chenwuz-msft]

Hi @Anonymous ,

This a limitation and you can refer this article.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-export#considerations-and-troubleshooting 

Or you can connect to the power bi directly via excel.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitations 

Best Regards

Community Support Team _ chenwu zhu

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

[aj1973 · Accepted solution]

Hi @Anonymous 

On the service you need the Paginated Report feature of Power BI to export more than 150K rows. for that you will need PPU or Premium Capacity.