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 have especially with functions used to access data sources, well 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 that all of these artefacts have in common is that 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 attended the talk thank you so much for attending. If 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 of pages at once is no fun task. However, there 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 as activity, memory usage, active users, and more. However, to 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 this post I am going to built on these to 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 number of reports. Especially if you do not have access 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 after a short delay. At the time I used a 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 this only applies to the object connector. The object connector 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 and budgets broken out by date. This is not an Read more…