SOLVED

CQD - Out-of-the-box reports

%3CLINGO-SUB%20id%3D%22lingo-sub-1139477%22%20slang%3D%22en-US%22%3ECQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1139477%22%20slang%3D%22en-US%22%3E%3CP%3EBased%20on%20below%20link%20%2C%20power%20bi%20query%20template%20is%20available%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fturning-on-and-using-call-quality-dashboard%23out-of-the-box-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fturning-on-and-using-call-quality-dashboard%23out-of-the-box-reports%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20i%20open%20the%20Template%20getting%20below%20error%20%3A%3C%2FP%3E%3CP%3E%22We%20couldn't%20connect%20to%20your%20directory%20query%20data%20source%20or%20internal%20model%20.%20Double%20check%20your%20server%20and%20database%20name%20are%20correct%2Cand%20that%20you%20have%20permission%20to%20access%20them.%3C%2FP%3E%3CP%3EOLE%20DB%20or%20ODBC%20error%3A%20%5BExpression.Error%5D%20The%20import%20MicrosoftCallQuality.GenerateTable%20matches%20no%20exports.%20Did%20you%20miss%20a%20module%20reference%3F.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20will%20be%20much%20appreciated%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1139477%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1139754%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1139754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F454151%22%20target%3D%22_blank%22%3E%40jijo_paul%3C%2FA%3E%26nbsp%3BCan%20confirm%20same%20for%20myself%20as%20well.%26nbsp%3B%20Excited%20about%20the%20possibilities%20of%20this%20but%20this%20likely%20got%20rushed%20out%20the%20door%20without%20sufficient%20vetting%20and%20documentation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EItems%20to%20Note%3A%3C%2FP%3E%3CUL%3E%3CLI%3EQuery1%20maps%20to%20that%20MicrosoftCallQuality.GenerateTable%2C%20which%20isn't%20defined%20or%20doesn't%20exist%20in%20any%20of%20the%20reports.%3C%2FLI%3E%3CLI%3ETenantID%20was%20hardcoded%20to%20a%20tenant%20which%20was%20not%20my%20tenant.%20Changing%20the%20tenantID%20did%20not%20resolve%20anything%20but%20I%20suspect%20it%20will%20ultimately%20be%20required%20to%20retrieve%20my%20tenant's%20actual%20data.%3C%2FLI%3E%3CLI%3EThere%20is%20a%20query%20for%20BuildingFilterString%20which%20has%20several%20items%20hardcoded.%26nbsp%3B%20Not%20sure%20if%20this%20is%20affecting%20anything%2C%20but%20the%20buildings%20listed%20in%20the%20filter%20will%20certainly%20not%20be%20in%20actual%20customer%20environments.%3C%2FLI%3E%3CLI%3EThere%20is%20a%20query%20for%20Buildings%20that%20has%20seven%20Applied%20Steps%20to%20it%20that%20alter%20and%20manipulate%20data.%26nbsp%3B%20The%20steps%20don't%20seem%20to%20serve%20a%20purpose%20and%20likely%20are%20testing%20remnants%2C%20but%20just%20seem%20to%20be%20messy%20and%20unnecessary.%3C%2FLI%3E%3CLI%3EDataSource%20is%20hardcoded%20to%20cqd.teams.microsoft.com%2Fdata%2Fnoam.%26nbsp%3B%20Customers%20that%20are%20not%20US%20tenant%20based%20may%20need%20to%20change%20this%20value.%3C%2FLI%3E%3C%2FUL%3E%3CP%3ELikely%20more%20to%20come%20from%20the%20product%20group%20on%20this%2C%20but%20there%20are%20definitely%20items%20that%20require%20fixing%20or%20documentation%20to%20actually%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1141655%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F454151%22%20target%3D%22_blank%22%3E%40jijo_paul%3C%2FA%3E%26nbsp%3BWe%20got%20the%20templates%20working%20by%20using%20the%20Power%20BI%20web%20app.%20Once%20you%20have%20the%20template%20uploaded%2C%20click%20on%20the%20Settings%20icon%20in%20the%20upper-right%20hand%20side%20and%20then%20click%20on%20Settings%20in%20the%20dropdown.%20Click%20on%20Datasets%20and%20expand%20Data%20source%20credentials.%20Edit%20credentials%20with%20your%20Teams%20admin%20account.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20weren't%20able%20to%20get%20the%20templates%20working%20using%20the%20Power%20BI%20desktop%20app%20but%20were%20able%20to%20get%20them%20working%20with%20the%20web%20app.%20The%20reports%20look%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1141749%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141749%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18049%22%20target%3D%22_blank%22%3E%40Mary%20Patton%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAhhh......%26nbsp%3B%20I'll%20give%20that%20a%20shot%20later.%26nbsp%3B%20Bummer%20that%20PowerBI%20Desktop%20won't%20work%20but%20glad%20to%20hear%20it%26nbsp%3B%3CEM%3Edoes%26nbsp%3B%3C%2FEM%3Ework%20in%20Power%20BI%20on%20the%20web.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20heads%20up!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569261%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18049%22%20target%3D%22_blank%22%3E%40Mary%20Patton%3C%2FA%3EHow%20do%20I%20import%20the%20Call%20quality%20templates%20into%20POwer%20BI%20online%3F%26nbsp%3B%20I%20don't%20see%20an%20obvious%20option%20to%20upload%20a%20report%20or%20template%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569265%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569265%22%20slang%3D%22en-US%22%3EHow%20do%20I%20upload%20the%20template%20into%20power%20bi%20online%3F%20I%20got%20them%20downloaded%20but%20not%20sure%20how%20to%20get%20them%20into%20the%20online%20interface%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570382%22%20slang%3D%22en-US%22%3ERe%3A%20CQD%20-%20Out-of-the-box%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570382%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F32775%22%20target%3D%22_blank%22%3E%40Tom%20Nohelty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20download%20the%20Power%20BI%20Desktop%20app%2C%20open%20the%20template%20file%20from%20there%2C%20and%20choose%20the%20%22Publish%22%20option.%20The%20desktop%20app%20is%20the%20only%20way%20to%20get%20the%20reports%20into%20Power%20BI%20online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fcreate-reports%2Fdesktop-upload-desktop-files%23to-publish-a-power-bi-desktop-dataset-and-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fcreate-reports%2Fdesktop-upload-desktop-files%23to-publish-a-power-bi-desktop-dataset-and-reports%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Based on below link , power bi query template is available 

 

https://docs.microsoft.com/en-us/microsoftteams/turning-on-and-using-call-quality-dashboard#out-of-t...

 

But when i open the Template getting below error :

"We couldn't connect to your directory query data source or internal model . Double check your server and database name are correct,and that you have permission to access them.

OLE DB or ODBC error: [Expression.Error] The import MicrosoftCallQuality.GenerateTable matches no exports. Did you miss a module reference?."

 

Any help will be much appreciated .

 

 

6 Replies
Highlighted

@jijo_paul Can confirm same for myself as well.  Excited about the possibilities of this but this likely got rushed out the door without sufficient vetting and documentation.

 

Items to Note:

  • Query1 maps to that MicrosoftCallQuality.GenerateTable, which isn't defined or doesn't exist in any of the reports.
  • TenantID was hardcoded to a tenant which was not my tenant. Changing the tenantID did not resolve anything but I suspect it will ultimately be required to retrieve my tenant's actual data.
  • There is a query for BuildingFilterString which has several items hardcoded.  Not sure if this is affecting anything, but the buildings listed in the filter will certainly not be in actual customer environments.
  • There is a query for Buildings that has seven Applied Steps to it that alter and manipulate data.  The steps don't seem to serve a purpose and likely are testing remnants, but just seem to be messy and unnecessary.
  • DataSource is hardcoded to cqd.teams.microsoft.com/data/noam.  Customers that are not US tenant based may need to change this value.

Likely more to come from the product group on this, but there are definitely items that require fixing or documentation to actually use.

Highlighted
Best Response confirmed by jijo_paul (New Contributor)
Solution

@jijo_paul We got the templates working by using the Power BI web app. Once you have the template uploaded, click on the Settings icon in the upper-right hand side and then click on Settings in the dropdown. Click on Datasets and expand Data source credentials. Edit credentials with your Teams admin account. 

 

We weren't able to get the templates working using the Power BI desktop app but were able to get them working with the web app. The reports look great.

Highlighted

@Mary Patton 

Ahhh......  I'll give that a shot later.  Bummer that PowerBI Desktop won't work but glad to hear it does work in Power BI on the web.

 

Thanks for the heads up!

Highlighted

@Mary PattonHow do I import the Call quality templates into POwer BI online?  I don't see an obvious option to upload a report or template

Highlighted
How do I upload the template into power bi online? I got them downloaded but not sure how to get them into the online interface
Highlighted

@Tom Nohelty 

You need to download the Power BI Desktop app, open the template file from there, and choose the "Publish" option. The desktop app is the only way to get the reports into Power BI online.

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files#to-publish-a-p...