Forum Discussion
Automatically update usage statistics across multiple reports
Anonymous
This is possible. Thanks to the latest feature of Power BI, DQ for datasets, which allows you to connect to a dataset in Direct Query mode.
Whenever you generate usage metrics for a report, a dataset will be created in the same workspace named "Usage Metrics Report"
Once you generate the usage metrics in both workspaces, follow the below steps:
- Make sure you have the latest verison of PBI Desktop and enabled the DQ for datasets preview feature.
- Open PBI Desktop and click on Power BI datasets source and it will allow you to select a dataset
- Now search for "Usage Metrics Report" in the search box. (It will list all the available Usage Metrics dataset from all the workspaces)
- Select the datasets from your desired workspace1
- Repeat the process for the next Usage Metrics Report dataset from workspace2
Now you can build your own report.
Did I answer your question? Give a thumbs up and accept this as solution!
Thank you for this!
Few things I noticed, it seems like I can't do any manipulation within Power Query as in appending datasets/pivoting/unpivoting
Secondly, it will only let me add PowerBI from one source only, i.e. once a a PowerBI dataset is in, I can't bring in anything else. Not sure why its doing that
Anonymous
Did you enable the preview feature 'Direct Query for dataset' in desktop settings? That could be the reason why you are not able to add another dataset. I just tried and I was able to add multiple dataset connections in DQ mode.
And regarding appending tables, may be you can make use of Union() DAX function.
If not, seems it's possible to acheive this requirement with paginated report as explained in the below article.
(1) Automate Power BI Usage data across workspaces using Paginated Reports | LinkedIn