Sometimes a query in Microsoft Power BI will have so many fields that it is cumbersome. In this Tiny Tip, I will show you how to use folders to organize the query, making it easier to find the fields.
Author: Belinda Allen
Removing Duplicate Records in the Microsoft Power BI Query Editor
In this Tiny Tip, I will show you how to remove and check for duplicate records in the Microsoft Power BI Query Editor. In my example, I am pulling customer information from a Sales table. Hopefully, I am invoicing (or selling to) customers more than one time. Check out this tiny video on how I verify my data (aka repeat business).
Referencing a Query in the Microsoft Power BI Query Editor
In this Tiny Tip, I will show you how to break up a big flat query in the Microsoft Power BI Query Editor using Reference. This will prevent you from having to import the same data into your data model multiple times.
Creating a Template Page for Consistency in Microsoft Power BI
One of the first things I do when I start creating a Microsoft Power BI report is create a template page, which I call Blank. When creating a (new) page, I just duplicate the template/blank page and start building. This helps provide a consistent look for all my pages.
Importing data from a CSV Download into Microsoft Power BI
What if your Microsoft Power BI report needs to access data from a website, but the only option is a CSV download? In this tiny tip, Belinda will show you how to make a CSV download act like an API.
More SEC Football data modeling in Microsoft Power BI Query Editor
In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report. I show how I incorporate parameters with my data and I create a custom title for my report.
Creating a Custom Table in the Microsoft Power BI Query Editor
As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC); I will show you how I created a custom static table of the 14 teams in the SEC.
Displaying Images in the Data using Microsoft Power BI
I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC). In this video, I will show you have I get team logos from my dataset to display.
There’s Power Apps in my Microsoft Teams
Today, on the first day of the 2020 Virtual Microsoft Ignite, Project Oakdale was highlighted. What is Project Oakdale. It is like the old Reese’s Peanut Butter Cup commercial…. “There is a Power App in my Teams” or There’s Teams on my Power App.” Whichever way you say it, it ROCKS! In this video, I will show you the creation of a Power App, using a table that I’ll create in CDS, publishing it all on a Microsoft Teams Channel.
That’s right I said it, all in less than 10 minutes!
Creating Data Parameters with Suggested Values in Microsoft Power BI
I have shown you already how to create parameters with SQL Server data in Microsoft Power BI. This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list. By the way, if you are a US College (American) football fan, you will be excited about the report that is being built!