The background to this post was a request to provide an updated list of sites in our SharePoint environment for use as a data source in Power BI.
Row Level Security is not a dark art. Use it to make your TyGraph analytics more accessible whilst maintaining privacy
Creating new Microsoft To-Do items from emails is easy with Microsoft Flow
Whilst tracking through my OneDrive I rediscovered the theme I developed for an analytics session at Ignite 2017. I still think the theme is relevant today so I’ve decided to turn it into a blog post. If you were in the session you’ll notice that I’ve tweaked it a little bit 😉
This post will show you how to make a REST call to the SharePoint API and process the JSON response using Microsoft Flow.
The Document ID service is great but limited. Engineers tend to want more metadata in their IDs!
Using PowerApps to work around the limitation of only being able to embed Power BI dashboards in modern SharePoint pages
Recently I came across an excellent blog post from Jethro Seghers that covered getting started with Office 365 PowerShell Automation. In the post Jethro walks through the process of setting up Visual Studio Code to work with Visual Studio Services. The process uses Git as the broker. The end result is that your scripts can be stored in a secure source repository. In following the post I learned several lessons that I thought I'd share
The moral here is if you change the number of columns in a file you need to update the Source definition in Power BI
Quick post: geolocating your data in Power BI