cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kzkl111

Microsoft CQD powerbi dashboard not loading data based on filters

Submitted by on ‎01-22-2021 12:32 PM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
v-lili6-msft
Community Support
Community Support
‎01-24-2021 11:19 PM

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

Idea Statuses