PBI Embedded: Show raw data

[Anonymous]

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. 

[Stachu]

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