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

    Creating a Power BI Report from the Audit Logs stored in Azure Blob Storage

    by Gilbert Quevauvilliers April 8, 2020

    Following on from my blog post on How you can store All your Power BI Audit Logs easily and indefinitely in Azure, I wanted to share with you how I connected to the Blob Storage Files and created my Power BI report, to report on the audit logs. Pre-requisites Before starting with the Power BI report, I first had to…

    Azure, Power BI 5

    Power BI – Which Groups can be used to set Permissions in Power BI

    by Gilbert Quevauvilliers April 1, 2020

    There are quite a few areas where Power BI can assign permissions. Below is a list of which permissions can be assigned by which Groups that are available in Power BI. Explanation of Groups Security Group This is also known as an Active Directory Security Group. This group lives within Active Directory and Azure Active Directory. It is where you…

    Power BI 42

    Teams – Running a Live Event

    by Gilbert Quevauvilliers March 25, 2020

    What I then found is that when I ran my first live event (as a test) there were a few things that I had no idea how to complete it. I thought it would be good to have a follow up blog post on how to run the live event. In my previous blog post I demonstrated how to setup…

    Teams 0

    Microsoft Teams – Creating/Hosting a Live Event for User Group Meetings

    by Gilbert Quevauvilliers March 18, 2020

    With all the challenges we are facing with the COVID-19 almost all User Group Meetings and other meetings have now gone virtual. One of the features within Microsoft Teams is that you can create and host a Live Event. In this blog post I am going to cover how to configure and set this up “Events produced by Teams”. I…

    Teams 1

    How to configure Incremental Refreshing in Power BI with DateKey or Date (instead of the default DateTime)

    by Gilbert Quevauvilliers March 11, 2020

    I was helping on the Power BI community forum (where I certainly learn a lot) and I came across this blog post where a Microsoft Employee had suggested that a Power Query function could be used as part of the Incremental refresh. What I mean by this is when implementing Incremental refreshing in Power BI the default is that you…

    Power BI 25

    A Real implementation of Approximate Distinct Count vs DISTINCTCOUNT is 7X faster!

    by Gilbert Quevauvilliers March 4, 2020

    I am very fortunate to have known Phil Seamark for quite some time. And quite a while ago we were chatting, and Phil mentioned that he had this idea that he could get an approximate distinct count working where it could be VERY close to the actual DISTINCTCOUNT (Using DAX) If you are unaware one of the most expensive DAX…

    DAX, Power BI 7

    Ensuring your Power BI Incremental Refresh does not Timeout when using a SQL Server Source

    by Gilbert Quevauvilliers February 26, 2020

    I recently was updating my PBIX files to use the Incremental refresh. I ran into a timeout error as shown below. This was because on the first refresh it has to process all the data before it can incrementally refresh the dataset. As per the documentation the default timeout for a SQL Server database is set to 10 minutes, and…

    Power BI 10

    How to configure Azure Function App notifications for errors

    by Gilbert Quevauvilliers February 19, 2020

    Below are the steps to enable error notifications on Azure Function Apps Follows on from my previous blog post How you can store All your Power BI Audit Logs easily and indefinitely in Azure, where every day it extracts the Audit logs into Azure Blob storage. One of the key things when working with any job that runs, is that…

    Azure, Power BI 10

    How you can store All your Power BI Audit Logs easily and indefinitely in Azure

    by Gilbert Quevauvilliers February 12, 2020

    With the new Power BI Get-PowerBIActivityEvent I wanted to find a way where I could automate the entire process where it all runs in the cloud. One of the current challenges with the Audit logs is that they only store 90 days, so if you want to do analysis for longer than 90 days the log files have to be…

    Power BI 63

    Connecting to Snowflake DB in Power BI

    by Gilbert Quevauvilliers February 6, 2020

    Below are the steps to connect to Snowflake DB using DirectQuery for Power BI. The same steps can be included for Import Mode Installation of ODBC Drivers The first thing I did was to install the ODBC Drivers. I installed the 64bit drivers where I had my Power BI Desktop installed, and I also installed it on all the Servers…

    Power BI 11
    • Previous
    • 1
    • …
    • 15
    • 16
    • 17
    • 18
    • 19
    • 20
    • 21
    • …
    • 58
    • Next
    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.

     

    Loading Comments...
     

      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