Downloading csv from powerbi app service

[surbhi]

hi all,

i am not able to fully download csv from powerbi app service to my local desktop as it has more than 30,000 lines of data. How to fully download all data of csv in my local. Need guidance. (Note have a pro license)

[v-sdhruv]

Hi @surbhi ,

I am afraid I cant help you with that since Power BI service has its limitation of 30,000 rows for its export.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to 

https://support.fabric.microsoft.com/support/

or you can post your issues here
https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

Hope this helps!

[v-sdhruv]

Hi @surbhi ,

In that case, I recommend you use DAX studio since Power BI Service has limitation of 30,000 rows

Install DAX Studio

Open your .pbix file in Power BI Desktop

In DAX Studio, connect to the open Power BI model.

Run a DAX query like:
Evaluate YourTable

Click Export > CSV

Hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

[surbhi]

my reports end user don't know powerBI so simple export button in dashboard is all want they can do. So looking like that similiar solution

[v-sdhruv]

Hi @surbhi ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

[v-sdhruv]

Hi @surbhi ,

I just wanted to check in and ask if the suggestion provided was helpful?
Additionally you can even refer an already addressed similar query  here-

Export more than 30000 rows

Let us know if it helped.

Looking forward to your update!
Thank you!

[surbhi]

i am still looking any way to deal this issue from app.service portal only as paginated report is what i am not looking for

[v-sdhruv]

Hi @surbhi ,

Just wanted to check if you had the opportunity to review the suggestions provided?
Thank you @pallavi_r  for sharing the resource links.
If her response has addressed your query, please accept it as a solution so that other members can easily find it.

Thank You

[MasonMA]

@surbhi 

If you have report access then leverage DAX Stuido. It's one of the simplest ways to export entire csv data while maintaining report views. 
for details: 

https://youtu.be/WaUCYUHLHdw?si=dmAljuYmcsrUK3K9

[surbhi]

any alternative apart from dax studio. There are end users who are not familiar with powerbi so any easy solution for them from app service only.

[pallavi_r]

Hi @surbhi ,

If you need easy solution for end user to export, then go for paginated reports. That will no have any limitation on number of rows to export.

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder/export-reports-report-bu...

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

[surbhi]

how to create paginated reports. Please share any supporting documents if possible

[pallavi_r]

Hi @surbhi ,

Please check these links if it helps. There are lot of resources on this.

https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-...

https://www.youtube.com/watch?v=FnJUNYknfAo

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi