cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
apoorvajyoti Frequent Visitor
Frequent Visitor

PBI Embedded: Show raw data

Hi, 

 

I am trying to do the following:

 

1. I have a giant dataset (>50K row) with 200+ columns but I want to only show about 50 of them to the users on our embedded platform.

2. I want to be able to export such data. 

 

I have found an issue that I cannot see any way of actually copying out columns while they are still linked. Is there a way possible to do this?  

 

For export, there seems to be a limit mentioned here: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data for 30,000 rows. Can this be increased? 

 

Please help. 

1 REPLY 1
Super User
Super User

Re: PBI Embedded: Show raw data

if you export to xlsx rather than csv you can get 150k rows
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...


BTW instead of export, have you considered using Analyze in Excel?
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel