Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Export data using UnderlyingData option

Hi, We have a Power BI report developed using SSAS live query. When we try to export data to excel using "Underlying Data" option from Power BI service we are getting filesize < 2.5 MB only. But the...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please be aware of the limitations to exporting underlying data from service.

  • The maximum number of rows that can be exported to .xlsx is 150,000.
  • Export using Underlying data will not work if the data source is an Analysis Services live connection.

 

Is there any way to specify or configure download file size in Power BI service? 

I'm afraid this is not supported now.

 

Best regards,

Yuliana Gu