Blog

Well, I must start by saying that, even though I’m doing this tutorial, this goes a bit against the idea of Microsoft Teams. But, every person/organisation has it’s needs right? So here we are, going against all the logic behind Microsoft Teams and creating a mailing list to send a newsletter email to the members of our Team! We will be doing this using Power Automate mostly and also, of course, Power BI! Key words: Power Automate, Power BI, Microsoft Teams, OneDrive 1) Build

Are you interested in finance? Investing? Stock Market? Just want some finance data to play with? Want to build you fancy investments tracker? Do you want the latest stock market data and you don't know where to get it? Well... I might have a solution for you! Check this out... If you're into finance and stocks, you probably heard about Yahoo Finance. It has all the data of stock markets. The question is... how do you get it? It's not as complicated as you probably think it i

The other day I had a small challenge to solve. I wanted something that looked like a Multi Row Card but... with conditional formatting applied in the bars, and I also wanted to select any row to filter my other visuals in that report. In summary I wanted the multi row card combined with a table. To get to this solution though, you have to use a bit of imagination. I got a tip from one of my work colleagues that did something similar, so I adapted it into what I now call "The

Using Power BI Folder Connector can be a real pain. Whenever you use it Power BI will automatically create Parameters, Sample Files and Functions that sometimes can make your model refresh run incredibly slow (I'm sure if you're reading this you feel my pain). In this tutorial I will show you how to optimise the queries so that you don't need to use all those components. Let's start! 1. On the Home ribbon click on the Get Data button. Select Folder on the right side and click