How to create 10% of sample PBI file ?

[admin11]

Hi All

My PBI file have 20 table. if i using the keep approach , i need to do 20 time. it there a faster way to save 10% of the data ? 

[v-shex-msft]

HI @admin11,

Unfortalbebly, the current power query editor does not include bulk operating features. Perhaps you can submit ideas for these requirements.

Microsoft Power BI ideas

Regards,

Xiaoxin Sheng

[amitchandak]

@admin11 , The other way I can think of is that you put code for that 20 times. but that will be more time than what you do from the menu. I doubt we have macro in power query, which can repeat the task