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.
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
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 😉
Using PowerApps to work around the limitation of only being able to embed Power BI dashboards in modern SharePoint pages
The moral here is if you change the number of columns in a file you need to update the Source definition in Power BI