Have you ever been looking for a function in the Power Query function documentation and been unable to find the function that you can see right there in the M code Power BI has generated for you? I know I Read more…
What even is an id? The Power BI service is build up of many artefacts, some of which you are probably familiar with: reports, dashboards, workspaces, some of which you may not be: dataflows, capacities, gateways etc.One of the things Read more…
Yesterday I spoke at the London Power BI User group about power query. If you want to view the recording it should be available on skills matter shortly.You can also access the PowerPoint and Excel files on github. If you Read more…
Have you ever had to update the background image on a report with a lot of pages? Perhaps due to a corporate rebrand, or maybe you no longer like yellow. Whatever the reason, changing the background image on a bunch Read more…
Analysis services has a series of what are called Data Management Views, which are essentially a way of seeing a bunch of meta data about your analysis services instance. With DMVs you can see a whole host of information such Read more…
When Microsoft enabled the ability for measures to have a data category such as image or web URL back in August of 2018. Quite a few people started using this to show dynamic images such as sparklines or KPIs. In Read more…
Introduction I think that the Power BI REST API is one of the most overlooked features of Power BI. It is an immensely powerful tool that can save you a lot of time when it comes to maintaining a large Read more…
So back in my post about my submission to a London Power BI Challenge I mentioned how I had issues with the page I was trying to webscrape. This was because the links that I wanted didn’t load immediately but Read more…
Background First some background to both Salesforce and Query Folding. Salesforce is a popular cloud enterprise software provider. Which, more importantly for this post, has a Power Query connector. It actually has two, the object and the report connector. However Read more…
Most of the time tables only have one header, however when there are more than one it can be a challenge to transform it into a useful form. For this example I’ve created a table that contains made up actuals Read more…