Forum Discussion
M function to create new tables from list column with table values
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
- Anonymous8 years ago
Alexander24,
I am afraid that you would need to right-click on each row and select "Add as new query".
Regards,Lydia
3 Replies
- AnonymousNot applicable
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
Helper II
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
- AnonymousNot applicable
Alexander24,
I am afraid that you would need to right-click on each row and select "Add as new query".
Regards,Lydia