SfB Online/PowerBI?

%3CLINGO-SUB%20id%3D%22lingo-sub-65098%22%20slang%3D%22en-US%22%3ESfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65098%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20existing%20integration%20or%20visibility%20between%20SfB%20Online%20components%20(CQD%3F)%20and%20PowerBI%2C%20or%20is%20that%20on%20the%20roadmap%3F%20%26nbsp%3BI've%20seen%20a%20few%20uses%20of%20PowerBI%20reaching%20into%20a%20prem%20SfB%20db%2C%20but%20nothing%20for%20a%20pure%20Online%20deployment.%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-65098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMonitoring%20%26amp%3B%20Reporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65493%22%20slang%3D%22en-US%22%3ERe%3A%20SfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65493%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20seen%20some%20similar%20scripts%2C%20but%20I'm%20really%20looking%20for%20a%20way%20to%20leverage%20BI%20to%20get%20a%20high-level%20view%20of%20stats%2Ftrends%3B%20we%20have%2018%20sites%20and%20it'd%20be%20great%20to%20even%20see%20MOS%20scores%20in%20aggregate%20per%20site%20in%20realtime%2C%20etc.%20%26nbsp%3BI%20know%20the%20data's%20there%2C%20it's%20just%20a%20matter%20of%20letting%20MS's%20own%20platforms%20access%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65378%22%20slang%3D%22en-US%22%3ERe%3A%20SfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65378%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20Get-CsUserSession%26nbsp%3Bis%20cool%2C%20but%20requires%20GA%20permissions%20(well%2C%20or%20SfBO%20Admin%20ones)%2C%20which%20is%20a%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65279%22%20slang%3D%22en-US%22%3ERe%3A%20SfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65279%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20might%20not%20be%20the%20most%20elegant%20way%20to%20pull%20the%20raw%20data%20currently.%26nbsp%3B%20However%20I%20have%20been%20helping%20customers%20write%20powershell%20scripts%20(wrappers)%20using%20Get-CsUserSession.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-65207%22%20slang%3D%22en-US%22%3ERe%3A%20SfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-65207%22%20slang%3D%22en-US%22%3E%3CP%3E%2B1%20on%20that.%20With%20the%20old%20powershell%20cmdlets%2Freporting%20webservices%20being%20deprecated%20now%2C%20we%20desperately%20need%20new%20ways%20to%20get%20the%20data%20out.%20PowerBI%2C%20API%20access%2C%20new%20cmdlets%2C%20whatever%2C%20just%20give%20us%20something!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-406328%22%20slang%3D%22en-US%22%3ERe%3A%20SfB%20Online%2FPowerBI%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-406328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19799%22%20target%3D%22_blank%22%3E%40Justin%20Kingston%3C%2FA%3Eyes%20yes%20yes....%20i%20have%20been%20wondering%20the%20same%20thing%2C%20I%20would%20also%20like%20something%20available%20to%20show%20when%20365%20is%20having%20issues%20of%20its%20own%20so%20that%20we%20can%20show%20that%20any%20factors%20to%20down%20time%20were%20external...%20rather%20than%20going%20to%20down%20detector%20or%20a%20similar%20external%20site.%26nbsp%3B%20I%20do%20like%20a%20nice%20colourful%20chart%20to%20say...%20look....%20its%20not%20us....%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Is there any existing integration or visibility between SfB Online components (CQD?) and PowerBI, or is that on the roadmap?  I've seen a few uses of PowerBI reaching into a prem SfB db, but nothing for a pure Online deployment.    

5 Replies

+1 on that. With the old powershell cmdlets/reporting webservices being deprecated now, we desperately need new ways to get the data out. PowerBI, API access, new cmdlets, whatever, just give us something! :)

This might not be the most elegant way to pull the raw data currently.  However I have been helping customers write powershell scripts (wrappers) using Get-CsUserSession.

Yes, Get-CsUserSession is cool, but requires GA permissions (well, or SfBO Admin ones), which is a problem.

I've seen some similar scripts, but I'm really looking for a way to leverage BI to get a high-level view of stats/trends; we have 18 sites and it'd be great to even see MOS scores in aggregate per site in realtime, etc.  I know the data's there, it's just a matter of letting MS's own platforms access it.

@Justin Kingstonyes yes yes.... i have been wondering the same thing, I would also like something available to show when 365 is having issues of its own so that we can show that any factors to down time were external... rather than going to down detector or a similar external site.  I do like a nice colourful chart to say... look.... its not us.... :)