May 21, 2020
5 min

Get Microsoft Team Site members and create a mailing list with Power Automate and Power BI

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

2,576 views0 comments

Connect to Yahoo Finance - building a stock market tracker

Mara Pereira

May 13, 2020
4 min

Connect to Yahoo Finance - building a stock market tracker

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

9,278 views0 comments

Mara Pereira

May 7, 2020
2 min

Multi Row Card Reinvented

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

937 views0 comments

How to connect to Folders without the hassle of predefined Functions/Parameters

Mara Pereira

May 1, 2020
3 min

How to connect to Folders without the hassle of predefined Functions/Parameters

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

237 views0 comments