Forum Discussion
Report is not being exported in Excel
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
5 Replies
- Hariharan_R
Solution Sage
Hi, what is the size of the file when you export from Report Builder?
Thanks
Hari
size of file from report builder is 48.9 mb
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
Any suggestion please
- v-chenwuz-msft
Community Support
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.
