Forum Discussion
Struggling using API bringing in subitems from Monday board using M
Greetings! I have been using PBI for about 8 months, and dont have a lot of experience with M. We have some Monday boards that use subitems and we are having a hard time bringing those in to power b...
Hi erikgroupo,
So you mean the result table structure should dynamic change if the remote data source changes?
AFAIK, current power query will cache the table structures in the query steps and not auto change even if the source table structure changes.
If you want it keep/sync to the lastest structure, you may need to do some customize on power query functions.(e.g. invoke value from the previous step result in the following query steps initializations instead of use static text values)
Regards,
Xiaoxin Sheng