Incremental Refresh...export large dataset

[GRob]

If I choose to use incremental refresh, therefore stopping the ability to download the pbix file, is there any way to retrieve all the data in the file? I know there is a data export limit of 150,000 rows for an xls file.

Here is a scenario...I incremental refresh data daily from a source that only holds data for 30 days. So, after 30 days the original source data is no longer available....but it is held in the power bi dataset.

Is there any way to extract all underlying rows?

[amitchandak]

@GRob , check if R or Python can help

https://owlcation.com/stem/How-to-Export-Data-from-Power-BI