Forum Discussion
bhatsuchi
8 years agoFrequent Visitor
Using the Usage Metrics dataset with other datasets
Hi, I am trying to use the Usage metrics dataset of one of my dashboards and create another report with additional datasets from SQL server tables. However, I am unable to get data from any other...
v-frfei-msft
8 years agoCommunity Support
Hi bhatsuchi,
Based on my test, we can export the data of the users firstly as csv, then we can get the table and another database table merged by importing two tables in desktop.
Regards,
Frank
bhatsuchi
8 years agoFrequent Visitor
Thank you Frank, I don't think this will work in my case(Correct me if I'm wrong, though!). I need the usage metrics data periodically auto-refreshed too. Let's say once every hour. If I export it into a csv, is there a way of doing an auto-refresh on the file?
On the other hand, I found a solution template for usage metrics by Neal Analytics. I am looking at the possibilities of that resolving my problem. But it comes with a subscription fee and that may not be an accepted solution.