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 for a pure Online deployment.    

Monitoring & Reporting

5 Replies

  • WelshViking's avatar
    WelshViking
    Brass Contributor
    Apr 08, 2019

    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.... :)

  • 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.

Resources