Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to create dashboard on usage itself?

I have 4 reports in different workspaces. I want to create a dashboard on usage of it.   I know there is the (below) “View usage metrics report” option… but, I would like to combine all of them in ...
Need Help
  • edhans's avatar
    edhans
    4 years ago

    Open up Power BI desktop, and connect to a Power BI Dataset. Look for Usage. You can build your report off of that. To do multiple datasets, click on "Make Changes to this model" in the lower right corner of Power BI. You'll need the DirectQuery to Power BI Datasets feature (composite model) enabled in Preview settings.

    Once in the composite model, add your own dimension from wherever that is - another dataset, sharepoint list, whatever.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks it looks great!! Last question; for one workspace I have only “Report Usage Metrics Model”.

 

Whereas for others I have both “Report Usage Metrics Model” and a “Dashboard Usage Metrics Model”?

 

What is the difference?

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    I'm not 100% sure, but I suspect the workspace you are in has no dashboard and the others do. I guess the dashboard usage metrics model is created when a dashboard is created by a user.