Hi @Anonymous ,
Please check if you have transformations that prevent folding. If you don't have those transformations in https://docs.microsoft.com/zh-cn/power-query/power-query-folding#transformations-that-prevent-folding and you can't see view native query in applied steps, it states the source don't support query folding for power bi. As for how to support, I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
>> Any other way I can import less amount of data in PBI other than creating smaller/aggregated tables in the databases ?
Ensuring that appropriate datasource privacy levels are set, this can avoid requiring Power BI to load full results to produce a combined result across queries.
The model structure determines the data to load and has a direct impact on the model size. It can be designed to avoid loading unnecessary data by removing columns, removing rows (especially historic data) or by loading summarized data (at the expense of loading detailed data). Dramatic size reduction can be achieved by removing high cardinality columns (especially text columns) which do not store or compress very efficiently.
You can configure incremental refresh, but only if the data source supports 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
