Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

MS Teams Call quality Connector apply filters like Date

Hi ,


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.?




Community Support
Community Support

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors