Hi,
I need to create a table that is a union of more tables.
This tables are read from different pbix files using direct query. I used a preview function called power BI datasets under data hub items menu.
Every tables contain only measures.
I used union function and i create rows using ROW function.
Every row contains measures from one table.
UNIONTABEL =
Union (
row("Column1",table1[measure1],...,"ColumnN",table1[measureN])
row("Column1,table2[measure1],....,"ColumnN",table2[measureN])
row("Column1",tableN[measure1,....,"ColumnN",tableN[measureN])
)
So, i obtain an union table, but if update dataset, data in my UNIONTABLE is not update. But if i check measeures in tables, them are updated whit new data read on origin file.
I try to find a solution but i'm stuck.
Thanks a lot
Riccardo
