M function to create new tables from list column with table values

[Alexander24]

Hi

I have used the table.partition function to create a list where each row contains a table partitoned by month,

I know want to automatically expand each table value in each row into a new table,

I am doing this as a semi automatic incremental refresh, i.e i just turn off enable load for each month once the month has gone

Doing it this way instead of duplicating the source query and hardcoding filters,  so that way If i change my source query, I only need to change it there and not just create new tables and change the filters every time

Thanks

Alexander

[v-yuezhe-msft]

@Alexander24,

I can't think of any automatic approach to expand each table value into new tables. And in your scenario, it is not possible to achieve incremental refresh after you turn off enable load. 

However, you can use Power BI Desktop May release and Premisum license to achieve incremental refresh, for more details, please review the following blog.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/

Regards,
Lydia

[Alexander24]

Hi

No worries, I was just going to turn off all the months but the current month manually every month,

The company wont buy premium yet so I cant do that,

Thanks

Alexander

[v-yuezhe-msft · Accepted solution]

@Alexander24,

I am afraid that you would need to right-click on each row and select "Add as new query".

Regards,

Lydia