FourMoo | Microsoft Fabric | Power BI FourMoo | Microsoft Fabric | Power BI FourMoo | Microsoft Fabric | Power BI
  • Toggle menu
    FourMoo | Microsoft Fabric | Power BI FourMoo | Microsoft Fabric | Power BI FourMoo | Microsoft Fabric | Power BI
    • Home
    • Blog
    • Accelerators
    • Contact
      • Contact Us
      • About
      • About the name FourMoo
      • Why use FourMoo ?
      • Privacy & Cookies
    • Showcase
      • Power BI Support Issues
      • Unicode Characters
      • Custom Data Connectors with Strava data
      • What-If Analysis – Queensland Crime
      • Bookmarks
      • Change Tables
      • Financial Report
      • InfoGraphics
        • Power BI – Overview Infographic
        • Power BI – Embedded
        • Power BI – Free vs Pro Infographic
        • Power BI – Premium
        • Power BI – Gateway Infographic

    Using Power BI DirectLake in Microsoft Fabric

    by Gilbert Quevauvilliers May 24, 2023

    I am super excited to release this blog post and I cannot wait to start using Microsoft Fabric and all the different components. The goal of my blog post is to look at how I could use Microsoft Fabric from a Power BI developers point of view. Microsoft Fabric is a new all in one platform which includes Power BI….

    Microsoft Fabric, Power BI 9

    Power Query – How to run a query only if data is returned

    by Gilbert Quevauvilliers April 21, 2023

    I had a requirement where I wanted to only have the underlying query run if there was data in the table. As shown in the image below a query would run, scan 20GB and then return zero rows. After making the changes what then happens is an initial query runs which will count the number of rows and if there…

    Power BI, Power Query 4

    Updating your Query syntax in Power Query to show the entire query in M

    by Gilbert Quevauvilliers January 12, 2023

    Welcome to 2023, I am looking forward to an amazing year! I have seen this come up a few times in Twitter where there is an option to put in your own TSQL Query or DAX Query and the input box is very small and often you cannot see the entire query as shown below. I will show you how…

    Power BI, Power Query, Uncategorized 3

    Power Query – Appending text to end of column name

    by Gilbert Quevauvilliers November 16, 2022

    Power query can be so powerful and once again it came to my rescue. I had a requirement where I wanted to append some text to the end of each of the column names in my table. To do this I did the following below. This is what the columns looked like before the change. Next, I put in the…

    Power BI, Power Query 1

    Getting the lineage from a Power BI dataset to table to data source to original query

    by Gilbert Quevauvilliers October 19, 2022

    As often happens blog posts originate from a customer requesting something I have not figured out before. In this example the requirement was to be able to determine which data sources were being used by which tables, which were then associated to one or many Power BI datsets. While I was working through this I figured out I could take…

    Power BI 4

    Using an IN Condition for multiple values in Power Query (Power BI)

    by Gilbert Quevauvilliers July 13, 2022

    In the example I did not want to specify all the country names one row at a time. This not only takes a long time, but if I had to then make updates it could be painful too. The requirement was for certain countries to have their names and the rest be grouped into “Other Countries” I found this useful…

    Power BI, Power Query 3

    Known Issues Power BI Report with Alerting

    by Gilbert Quevauvilliers May 12, 2022

    I was actually working on my own version of the Known Issues Power BI report, when the Power BI team released their blog post New Power BI Known Issue page | Microsoft Power BI Blog | Microsoft Power BI In the steps below I am going to show you the report I created, and then how I configured it to…

    Power BI 4

    Power Query – Remove all characters before delimiter & after delimiter

    by Gilbert Quevauvilliers March 10, 2021

    Below is the Power Query Syntax where I wanted to move the characters before the delimiter. I must give credit to the Power BI Community who got me going with how to solve this. For reference: Solved: Rename all column headers removing part before to … – Microsoft Power BI Community This is an example of what my column name…

    Power BI, Power Query 3

    How to refresh Excel files faster in Power BI

    by Gilbert Quevauvilliers January 13, 2021

    I was recently getting an error when refreshing an Excel file that was stored in SharePoint online. This got me thinking what the issue is and is there a way to improve it and YES there is as detailed below. When I investigated this further, I found that my 17kb Excel file was using at least 616kb of data when…

    Power BI, Power Query 13

    Power Query (M) – Passing Parameters dynamically to a SQL Server Query

    by Gilbert Quevauvilliers October 8, 2020

    I had a requirement where the client wanted the capability to decide how much data to load from a SQL Server Query (TSQL). This was so that they could limit the dataset returned, as at times they did not need all the data. So below I demonstrate how to achieve this. NOTE: This will be slightly advanced because I had to…

    Power BI, Power Query 20
    • 1
    • 2
    • 3
    • 4
    • …
    • 6
    • Next

    Recent Posts

    • How to use SQL Code to write to Delta Tables in a Python Notebook
    • How to use SQL Code to read from Delta Tables in a Python Notebook
    • What are the advantages of using Python Notebook vs a Spark Notebook in Microsoft Fabric

    Tags

    Azure Azure Analysis Services BI-NSIGHT BI-RoundUp Dataflows DAX Microsoft Fabric Power BI Power BI Premium Power BI Premium Per User Power BI RoundUp Power Query Power Query SQL Server 2014 SQL Server Analysis Services SQL Server Analysis Services Tabular SQL Server Reporting Services SSAS Tabular Editor Teams Uncategorized
    WordPress Theme built by Shufflehound. Copyright @FourMoo 2024 | ABN 80 382 360 382

    This site uses functional cookies and external scripts to improve your experience.

    Privacy settings

    Privacy Settings

    This site uses functional cookies and external scripts to improve your experience. Which cookies and scripts are used and how they impact your visit is specified on the left. You may change your settings at any time. Your choices will not impact your visit.

    You can refer to the Privacy and Cookie Policy here: FourMoo Contact Form

    NOTE: These settings will only apply to the browser and device you are currently using.

    Consent for all content on Website

    Consent for all content

    Powered by Cookie Information