How to blend usage metrics data for multiple reports

[Harineeeeeeee]

I am trying to build combined usage metrics for

2-4 workspaces

So as a first step I generated usage metrics report in individual workspace and then imported into PowerBl desktop using get data -PowerBI datasets imported all the tables for building multiple workspace usage metrics lused union to combine all the table and also added another column with workspace name to identify so what issue I am facing here is there are some measures while union it is not coming how to pull the Measure values to the final union table? If i add all the measures it is stagnant values it is not changing based on report name, users etc

Please advise

Thanks in advance

[lbendlin · Accepted solution]

Use the tenant audit logs instead.