My blog on SharePoint, Power Platform and related stuff.
Category: Power BI
Microsoft is rolling out a new Power Platform integration for Microsoft Lists called Visualize the list. This latest addition creates an auto-generated Power BI report based on the underlying list schema. The auto-generated report provides an excellent starting point for users not proficient with Power BI. In this blog post I will show how to … Continue reading A first look at “Visualize the list” in Microsoft Lists
I’m sharing my slide-deck from my session on Power BI and SharePoint in Higher Education. The slide-deck can be downloaded below. Thanks to those that attended and thanks to SPS Toronto for having me. Thanks for stopping by. Norm spstoronto-normyoung_11-23-2019Download
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
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
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
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
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
Norm Young 