Category: Power BI & Fabric

  • New MS Learn AI Skills Challenge

    New MS Learn AI Skills Challenge

    A new Microsoft Learn challenge started today! It’s very similar to the previous one I posted about, but this time once you complete it, you get a FREE exam voucher. The previous challenge resulted in a 50% off voucher which is good, but free is better. 😄 Challenge Microsoft Learnpspier (Full URL: https://learn.microsoft.com/learn/challenges?id=b696c18d-7201-4aff-9c7d-d33014d93b25&WT.mc_id=DX-MVP-5002186) If you…

  • MS Learn Fabric Analytics Engineer Challenge Part 12

    MS Learn Fabric Analytics Engineer Challenge Part 12

    This post is the last in the series specifically about the modules in this Cloud Skills challenge. Yay! The deadline to complete the challenge is February 22, 2024, so I got there with 2 days to spare! This topic is also not covered on the exam, hence it is not being included in the Learn…

  • MS Learn Fabric Analytics Engineer Challenge Part 11

    MS Learn Fabric Analytics Engineer Challenge Part 11

    This post is about module 9 of the Cloud Challenge series. Like the previous post in this series, it is a topic not covered in the DP-600 exam based on the study guide I read at least. After this, there will be one more post to complete the modules in the challenge, just before the…

  • MS Learn Fabric Analytics Engineer Challenge Part 10

    MS Learn Fabric Analytics Engineer Challenge Part 10

    This post is about module 8 of the Cloud Challenge series. It’s the first of my series where there was no Learn Live video session for it. It is not a topic that is listed as covered by the DP-600 exam, although it is part of Microsoft Fabric and part of the skills challenge collection.…

  • MS Learn Fabric Analytics Engineer Challenge Part 9

    MS Learn Fabric Analytics Engineer Challenge Part 9

    This post is the last of the 9 that had a “Learn Together” live video session. The posts after this will cover the modules I missed, numbers 8, 9, and 13 to round out the rest of the challenge. The deadline for the challenge is coming up quickly (ends Feb 22, 2024), and as of…

  • MS Learn Fabric Analytics Engineer Challenge Part 8

    MS Learn Fabric Analytics Engineer Challenge Part 8

    This post is about module 11 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Part 5 (Ingesting data with Dataflows Gen2) Part 6 (Getting started with data warehouses) Part 7 (Administration of Microsoft Fabric)…

  • MS Learn Fabric Analytics Engineer Challenge Part 7

    MS Learn Fabric Analytics Engineer Challenge Part 7

    This post covers module 10 in the Cloud Skills challenge. This is where the video series and the challenge modules start to diverge a bit. Modules 8, 9 and 13 were not covered in the Learn Together video series, so I will be covering those last. Modules 10, 11 & 12 were covered in a…

  • MS Learn Fabric Analytics Engineer Challenge Part 6

    MS Learn Fabric Analytics Engineer Challenge Part 6

    This post is about module 7 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Part 5 (Ingesting data with Dataflows Gen2) Microsoft Learn Module Get started with data warehouses in Microsoft Fabric This module…

  • MS Learn Fabric Analytics Engineer Challenge Part 5

    MS Learn Fabric Analytics Engineer Challenge Part 5

    This post is about module 6 in the Cloud Skills challenge. Previous posts in this series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Part 4 (Using Data Factory pipelines) Microsoft Learn Module Ingest Data with Dataflows Gen2 in Microsoft Fabric This module is about Dataflows Gen2, a cloud-based ETL…

  • MS Learn Fabric Analytics Engineer Challenge Part 4

    MS Learn Fabric Analytics Engineer Challenge Part 4

    This post is about module 4 in the Cloud Skills challenge. Previous posts in the series: Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Part 3 (Delta Lake tables) Microsoft Learn Module Use Data Factory Pipelines in Microsoft Fabric This module is about Data pipelines, which will be familiar to anyone who uses Azure Data…

  • MS Learn Fabric Analytics Engineer Challenge Part 3

    MS Learn Fabric Analytics Engineer Challenge Part 3

    This post is about module 3 in the Cloud Skills challenge. Previous posts in the series Part 1 (Introduction, Lakehouses) Part 2 (Apache Spark) Microsoft Learn Module 3 Working with Delta Lake tables in Microsoft Fabric This module is about the Delta Lake storage format in lakehouses, creating and working with delta tables in Spark.…

  • MS Learn Fabric Analytics Engineer Challenge Part 2

    MS Learn Fabric Analytics Engineer Challenge Part 2

    In this post, I am covering module 3 of the Microsoft Learn challenge. Previous posts in the series Part 1 (Introduction, Lakehouses) Microsoft Learn Module 2 Use Apache Spark in Microsoft Fabric This module shows how to configure and use Apache Spark for data processing and analytics in Microsoft Fabric. Spark is frequently used in…

  • MS Learn Fabric Analytics Engineer Challenge Part 1

    MS Learn Fabric Analytics Engineer Challenge Part 1

    As I wrote in my introductory post a couple of days ago (which can be found here), this is the start of a series following my journey through the Microsoft Learn cloud skills challenge “Fabric Analytics Engineer“. I’m coming from a Power BI perspective, so the majority of Microsoft Fabric components I have not been…

  • Microsoft Fabric Analytics Engineer challenge

    If you happen to follow me on LinkedIn, you may have seen some of my posts recently about the “Learn Together” Microsoft Fabric live training series. As I watched each of the 9 sessions over the past 3 weeks, I would post a note about each with a link. Now I’m going to write a…

  • Power BI, Excel & GP – SQL sources

    Today’s post combines the topics of the previous two posts and moves into Power Query to connect to SQL directly instead of connecting to static, exported SmartLists or flat files. Previous posts in the series Introduction Starting from scratch Data Access What this post covers In this post, I am using the same context of…

  • Power BI, Excel & GP – Data Access

    This is the third post in the series and I am going to dedicate this post to how to access GP data in terms of describing some of the options and factors to consider. Very little of this will have “how to” information about Power Query, but I will continue that in the next post.…

  • Power BI, Excel & GP – Starting from scratch

    The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query, starting from scratch. From my experience, an audience that is often overlooked is users who want to learn more or improve their skills but don’t know where to…

  • Power BI, Excel & Dynamics GP

    Soon I will be starting a new series of posts around Dynamics GP and how to get data out of it with Power BI or Excel via Power Query. There is no shortage of reporting options available for Dynamics GP customers, with many ISV (3rd party) products out there to augment some out-of-the-box options (Report…

  • Clear Recent Items list in Power BI Desktop

    Today’s tip I found completely by accident. In the Open Report window, I had a long list of previous Power BI reports in my “recently used” list, many of which I had long ago deleted or moved. I wanted to clear the list and could not find a way to do that on that screen.…

  • Power BI number formatting tips

    Here are two tips that I use repeatedly when building reports in Power BI. “Repeatedly” is a bit of a stretch as I’m still a newbie with Power BI but this was remarkably hard to find so I’m blogging for my future self, when I forget. 😄 For Tip #1, I love being able to…

  • Power BI matrix column width sizing

    I’ve been working with Power BI a lot lately on a “passion project” for myself. I’ll be starting to share more about that in the coming days but first I wanted to share a little tip (that I wish we didn’t need!) for sizing columns on Matrix visuals in Power BI. I’ve read many other…