Infographic: Power BI – Unpivot Columns

One of the most common  data cleansing  operations performed in Power Query is the removal of unwanted rows. And this is a topic which we cover in almost all of our Power BI training courses. In this blog post, we will look at the key M function used to suppress unwanted rows. Table.Skip The first…

Mobile-optimized Reports Mobile reports are based on the regular web report which you will have already created, with the layout adapted and optimized for mobile. For example, adapting a four-column desktop layout into a single-column mobile one. Page-by-Page Layout Mobile reports must be designed on a page-by-page basis, with a separate design for each page,…

Part 4 (of 4): Creating a Report in Power BI Desktop 2 Click here to download the tutorial work files Power BI online training In the previous tutorial in this series, we discussed the use of the synoptic panel custom visual to build a car damage report; and we examined the completed report. In this…

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). However, there is a huge overlap between the two exams resulting from the common BI features found in both Power BI and Excel: namely data modelling using…

Part 2 (of 4): Working in the Query Editor Click here to download the tutorial work files Power BI online training Let us now look in a bit more detail at the three parts of Power BI that we saw earlier: Power BI Desktop, the Power BI service and Power BI mobile apps. We will…

(In this blog post/tutorial, we will use a database called “Event Sales”, which you can download here. If you wish to follow along, you will need to download and UnZip the .BAK file, then use it to restore the EventSales database on an instance of SQL Server.) When connecting to a relational database from Power…