Microsoft CQD powerbi dashboard not loading data based on filters

[kzkl111]

Microsoft, Call Quality Dashboard for Teams not loading based on the filter data. It keeps throwing the error message.

(1/23/2021 1:23:22 AM) Message: Software usage metrics are disabled. (Type: 1, Category: 289, Event ID: 0x4121000E)
(23-01-2021 01:25:45) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:25:56) Message: OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://cqd.teams.microsoft.com/data/emea/DimensionMembers' (500): Internal Server Error. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:27:43) Message: OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://cqd.teams.microsoft.com/data/emea/DimensionMembers' (500): Internal Server Error. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:19) Message: OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://cqd.teams.microsoft.com/data/emea/DimensionMembers' (500): Internal Server Error. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:42) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:42) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:42) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:43) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:45) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:46) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:46) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:46) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:46) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:46) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:51) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:28:57) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:02) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:06) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:09) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:11) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:15) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:19) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:22) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:36) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:29:44) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:30:01) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:30:01) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:30:04) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:30:22) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:18) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:18) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:18) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:18) Message: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:39) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:41) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:47) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:48) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:50) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:51) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:54) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:47:57) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)
(23-01-2021 01:48:56) Message: OLE DB or ODBC error: [Expression.Error] CQD Query Execution Error (ErrorType: 3). (Type: 3, Category: 289, Event ID: 0xC1210003)

[v-lili6-msft]

hi

please check this:

Next, select any dimensions you want to filter on and drag them to the Filters on this visual field in the Filters pane. The CQD Power BI 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 Advanced CQD), and Relative date filtering (only available for the End Time and Start Time dimensions). Filtering according to Top N is not supported by CQD.

and also if the visual meet these limitations

https://docs.microsoft.com/en-us/microsoftteams/cqd-power-bi-connector#limitations

Regards,

Lin