Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to reduce data ?

Hi All   May i know how to reduce the data for PBI file ? So that i don't need to send the big file size to forum.   Paul Yeo
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi All

Thank you for all your sharing.

Sorry my question is not so clear. what i mean is if my PBI file have 1000 row of data , may i know how to reduce to 10 row of data ?

Paul

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

If your data source supports query folding(Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.), you can just filter your query to 10 rows in query editor. Otherwise, you need to filter your data in your data source.

 

For more details, please refer to https://docs.microsoft.com/en-us/power-query/power-query-folding

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai