Export more than 30K rows from power bi report server to excel

[Anonymous]

Dear All 

I am back with  a question , Please suggest me with your expertise .

Is it possible to export more than 30 K from power bi to excel ?  If yes , how can i do it 

I heard some days back , Power BI is going to increase this export limit , is it alraedy in place ?

need your valauble suggestions please .

[v-lionel-msft]

Hi @Anonymous ,

You can find the answer in this article:

Export the data that was used to create a visualization 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a . csv file is 30,000.
To import the file into Excel:

1. Open Excel.
2. Go to the Data tab.
3. Select Get external data > From text.
4. Go to the local folder where the file is stored and select the . csv.

[SpiroswayGR]

@Anonymous 

You can publish your report and then you can download it to excel from app.powerbi.com 

https://prnt.sc/r2aw4z 

[Anonymous]

Hi , We dont have the gateway set now to publish the report . We just host it in Power BI report server from where user export it to excel . We can not host in app.powerbi.com very soon 

Do you have any other methods to export more than 30 K from power bi reportbserver ? 

[SpiroswayGR]

@Anonymous 

it's shared server so you can log in with your account here https://app.powerbi.com/home . 

or with Rscript https://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/