Power BI Desktop is an excellent tool for ETL (extract, transform and load) operations and can perform almost any transformation that its big brother, SSIS (SQL Server Integration Services) can. Most ETL operations can be performed with no code - this is a big plus for those new to Power BI or for rapid report … Continue reading Data Validation with Power BI
No Code Data Exploration with Power BI
Power BI is an excellent data visualization tool but for data exploration Power BI is not a traditional choice. Tools like R and Python are two of the most popular data exploration tools on the market but come with a steep learning curve in order to master syntax and all of the other complexities that … Continue reading No Code Data Exploration with Power BI
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
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
