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
