Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Gau786

Data limitation while exporting PBI report data to Excel

Submitted by Advocate I on ‎01-10-2018 04:12 AM

I have approx 3,00,000 of data in the report. But when I am exporting the data in excel it shows on 1,50,000  of data. I searched this issue on google and deduce that there is a limit of 1,50,000 rows of data while exporting in excel. How can I export entire data on excel? Please suggest. I am using Direct Query in our report.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-jiascu-msft
Microsoft Employee
Microsoft Employee
‎01-11-2018 01:55 AM

Hi @Gau786,

 

I'm afraid there isn't a good way to do so. Please vote up this idea.

 

Best Regards,

Dale

Idea Statuses