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.
Using Power BI Row Level Security with TyGraph Yammer analytics
Row Level Security is not a dark art. Use it to make your TyGraph analytics more accessible whilst maintaining privacy
Creating To-Do items from emails
Creating new Microsoft To-Do items from emails is easy with Microsoft Flow
Mining Yammer data for Gold
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 😉
Counting SharePoint users using Microsoft Flow
This post will show you how to make a REST call to the SharePoint API and process the JSON response using Microsoft Flow.
Automatic document numbering using Microsoft Flow
The Document ID service is great but limited. Engineers tend to want more metadata in their IDs!
For the citizen developer: embed a Power BI dashboard in a classic SharePoint page
Using PowerApps to work around the limitation of only being able to embed Power BI dashboards in modern SharePoint pages
Lessons learned from setting up Visual Studio Code to work with Visual Studio Services
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
Power BI: CSV refresh failure
The moral here is if you change the number of columns in a file you need to update the Source definition in Power BI
Where’s my Power BI data?
Quick post: geolocating your data in Power BI
