Filling cells, say with colour, beyond the range where it is absolutely needed can lead to problems when importing Excel spreadsheets into Power BI. Performance gains can be made by removing formatting.
SharePoint Search results as a CSV file using Microsoft Flow
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
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 😉
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
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
