Report is not being exported in Excel

[Ravindra1590]

Hi Team,

Please advice !!

I have created paginated report, I am able to get report in Excel format when i would select 2k rows but when i will try to get a  excel format report of 109642 rows then refresh button keep rotating rather than giving me excel file.

One more thing is able to get excel report of 109642 rows in report builder but issue is with Power BI Online service though having an access of PPU(Premium Per User) capacity

[v-chenwuz-msft]

Hi @Ravindra1590 ,

Maybe you can use the rest api to export paginated reports. When the exportToFile API is called, it triggers an export job. After triggering an export job, use polling to track the job, until it's complete.

Export Power BI embedded analytics paginated reports API - Power BI | Microsoft Docs

REST API Power BI Integration: 2 Easy Methods (hevodata.com)

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.

[Ravindra1590]

Any suggestion please

[Ravindra1590]

Thanks for replying, able to get excel report from report builder but samething is not being done through power bi online service because it's published over there. Size of file is 48.9 MB

[Hariharan_R]

Hi, what is the size of the file when you export from Report Builder? 

Thanks

Hari

[Ravindra1590]

size of file from report builder is 48.9 mb