Forum Discussion

Justin Kingston's avatar
Justin Kingston
Iron Contributor
Apr 26, 2017

SfB Online/PowerBI?

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 ...
Monitoring & Reporting
VasilMichev's avatar
VasilMichev
MVP
Apr 26, 2017

+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! :)

Geoff Clark's avatar
Geoff Clark
Icon for Microsoft rankMicrosoft
Apr 26, 2017

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.

  • Justin Kingston's avatar
    Justin Kingston
    Iron Contributor
    Apr 27, 2017

    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.

  • VasilMichev's avatar
    VasilMichev
    MVP
    Apr 27, 2017

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

Resources