Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When we are download the Power BI Service to Excel 150000 records data only. If we above 150000 records data for download what is option. Please help me on that.
mail Id : usmanbasha498@gmail.com
Hi @Usmanbasha1 ,
This is a limitation of the tool. Although, if you use LiveConnection export with Summarized data you can get to 500,000 rows.
That said, if you add slicers to the report that cut your data below 150,000 per slicer, then you can use that and make multiple exports and then put them back together in Excel. But, Excel has a limit of 1 million rows.
The real question to me is from the business side - what is happening in Excel that is not happening in Power BI that there is a need to export? Maybe you can resolve that by adding something to the report in Power BI that lets the users do what they need without exporting.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Fine the Attached Screen shot of related above message.