Power Query

[Anonymous]

Suppose I have 500 tables and I need to expand those tables and need to apply the same query to all those tables, So how can we do that. 

[V-pazhen-msft · Accepted solution]

@Anonymous 

If you have aggregated all table in one query table, you can expand all tables then create a query on the expanded step, however this could take sometime if you have huge amount of data/

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[AntoineTRICHET]

Hi @Anonymous 

You can use a function. But charging 500 tables in a Power BI is maybe to ambitious (performances and dataset size limit). If your 500 tables have the same structure you can combine your tables (native functionnality : https://www.youtube.com/watch?v=RAmSdxt863s) to get one unique table (with more rows but common columns). Combining the table will create a function and you will be able to add steps done by this function during the combination of the table (such as expanding those tables and apply common transformation).
I hope it will help you.

Please accept it as a solution if it answers your question