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?
if you export to xlsx rather than csv you can get 150k rows
BTW instead of export, have you considered using Analyze in Excel?