Category: Power BI

Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 2

Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 2

In Part 1 of this blog, we extracted Audit Log data from Office 365 using PowerShell and stored it in SharePoint for the purposes of quantifying Power BI adoption. In Part 2 we will transform and visualize the Audit Log data using Power BI. We’ll focus on: connecting and transforming the Audit Data from JSON … Continue reading Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 2

Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 1

Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 1

The Power BI Office 365 Adoption content pack provides insight into Exchange, OneDrive, SharePoint, Skype and Yammer. Surprisingly it does not include Power BI. As of September 2017, the Power BI Service includes usage metrics for dashboards and reports. The usage metrics are excellent for dashboard and report consumption but they do not lend themselves … Continue reading Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 1

Power BI Group management using Active Directory roles and PowerShell

Office 365 Groups are an excellent way of scoping and securing Power BI content for end users. In addition to a content and security container the Group construct offers the best of Office 365 with hooks into OneDrive for Business, Outlook, Planner, SharePoint, Stream and Yammer. Manually maintaining Power BI Group membership on a small … Continue reading Power BI Group management using Active Directory roles and PowerShell