I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last two functions I create for Power BI Report Server for a little while. I’ll be working on SSAS cmdlets for the next week or two. RECAP… READ MORE
After Installing the PowerShell Power BI Management cmdlets a few months back, I finally managed to get a dataset refresh working, initiated from PowerShell with a Service Principal. Yeej 🙂 But as you can imagine, it didn’t go without a fight (or 2, or maybe more), so I thought it would probably be good to share my… READ MORE
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE
When your report has a bunch of slicers and charts that can also add filters to the page resetting back to no filters can be painful. So we need a quick way to reset slicers. This post walks through the steps of creating a bookmark and the using that bookmark to reset the page by… READ MORE
We have been waiting for this for soooo long! I’m very happy to announce the availability of the Power BI report web part for SharePoint Online! The new web part Microsoft is releasing today enables SharePoint authors to embed Power BI reports directly in SharePoint Online pages with no code required! In the sample below I… READ MORE
Grow and enhance your skills with the European SharePoint, Office 365 & Azure Community. Joining the ESPC Community, gives you access to the online resource centre at sharepointeurope.com, providing the best, free content on SharePoint, Azure and Office 365. Topics covered include Microsoft Teams, SharePoint, SharePoint Framework, Office 365 Groups, OneDrive, PowerApps & Flow, Security,… READ MORE
Analyse your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualisations and share them with your colleagues. This excerpt ‘Data Munging with Power Query’ from the book Beginning Power BI by Dan Clark… READ MORE
This post is the second in a series exploring Power BI and complex data types in SharePoint. The first post explores working with multi-value columns. In this one, we’ll explore some of the nuances of working with person fields Person fields in SharePoint are just a special case of the lookup field, and the Power BI SharePoint… READ MORE
Power BI has direct support for reporting on SharePoint lists and documents whether SharePoint is on-premises or in the cloud. Getting at your data is relatively straightforward if you know the URL, but as I’ve written about before, SharePoint data can be idiosyncratic. Text and number fields work right away, but more complex data types… READ MORE
