MS Teams Call quality Connector apply filters like Date

[Satya_Machari]

Hi ,

Greetings!

I am using powerbi Microsoft call quality connector in my report and able to get all fields. But here problem is powerbi dataset is becomes very large if pull all the data.So I want filter only some measures/fields by applying filter like forexample 1 day into my powerbi dataset and get only VDI based call using Measures Virtualization.

I am trying to apply in powerbi from AdvancedEditor but it is just showing only one line as " Source = MicrosoftCallQuality.GenerateTable(null, null)".

Please suggest how can we apply filter and get required data only instead of getting all  the data.?

Thanks

Satya

[v-jingzhang]

Hi @Satya_Machari 

I don't have a credential to connect to Call Quality Dashboard so I'm not able to test this connector. According to the document (Install Power BI Connector to use CQD query templates), it seems this connector loads the entire data model for Call Quality Dashboard into Power BI, so perhaps it doesn't allow you to filter rows by design. 

Since the Microsoft Call Quality connector only supports DirectQuery in Power BI, you can try using the filter pane to set filters on Dimension fields in visuals. This will add filters to queries that are sent to the data source to reduce the data returned to the visuals.

Please notice that the Microsoft Call Quality connector currently supports Basic filtering (select values from a list of possible dimension values), Advanced filtering (manually specify values and operands to filter on, similar to Call Quality Dashboard), and Relative date filtering (only available for the End Time and Start Time dimensions). Filtering according to Top N isn't supported by Call Quality Dashboard. Filters are only supported when applied to Dimensions. Filtering on the values of Measurements is not supported in Call Quality Dashboard.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.