cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft CQD powerbi dashboard not loading data based on filters

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

Dashboard Issue.JPG

 

(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)

Status: New
Comments
Community Support

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