Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Microsoft QER Template - Issues using Data

Hi, everyone

 

So I'm using the Microsoft QER Template to analyze the Teams call quality. But I wanna make some custom reports from its dataset. This report is fed with a table called CQD that it's built with DirectQuery. The thing is that there's no relationship in the data when I try to built some custom dashboards. Like if I want to do a replica of some visuals of the template, they don't work same way and for example, when I filter on a table it doesn't affect other table. So it's like the relationships are just working on the default template visuals, but not my custom ones.

 

My last goal was making some queries against the dataset to get some info and export them to CSV with Power Automate, but these queries get some errors* and I guess it's because it's working with this unrelated data or at least I don't know how to work with.

Does anyone know how this work and if I can get it?

Thanks.

 

*So the most common error I get making the queries is:

External component has thrown an exception.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.

 

1 Reply