Export Summarized data into .xlsx from Embedded application

Hi All,

I am trying to export summarized data into xlsx (Excel 150000 rows max) from embeded application, but it is not exprting any data. it just export empty file with only headers. But the same is working with CSV.

Note: I am able to perform the same action in power bi service and it is working as expected.

Can anyone help me on the same.

Thanks,

Venki.