The Algebra Teacher Powers to B.I.

  Power BI can connect to a plethora of different data sources.   Did you know Power BI can also make loading multiple files at one time a cinch?   There is an option from the Get Data icon for “Folder”.   Wait, a folder is not a data source, is it?   Well, all the files in that folder are for sure data sources. So what makes the “Folder” option something you need to know about?   Do you get new files with the same column structure sent to you on a set time frame and then have to go and append them to your existing file?   Have you ever found yourself appending multiple files over and over that have the same column structure?   If you answered yes to any of those last 2 questions, then you are going to fall in love with the “Folder” data source. Simply put, the “Folder” option allows you to bring in all of your files at once into Power BI.   You will then make all of your transforms on one sample file and Power BI will automate the proces...

According to The Old Farmers Almanac , a "full moon on Halloween only occurs roughly once every 19 years. If the full moons are calculated using Greenwich Mean Time, that translates to approximately three to four times per century." And on the day I am writing this post, October 31 st of the year 2020, there is a full moon.   Spooky, huh?   Frightening? Maybe. But not as scary as having too many calculated measures in your Power BI reports! <Ba dum tss> Okay, so maybe the full moon and candy are getting to me.   If you have made calculated measures for your reports, you know that they can quickly become quite numerous.   Also, if you are not aware yet a measure only gets run when brought into a visual and a measure is dynamic.   This means that a measure does not need to be housed/located on a specific table in order to function.   So the question becomes where should I put my measures.   There are a few ways to organize these.   1)...