Hat Full of Data

1st September 2022

Power BI Dataverse Connector – July 2022 Update

In the July 2022 Power BI update, they updated the Dataverse connector. The connector now uses the display names from a Dataverse table. Dataverse columns have internal name and display names and previously the display names were not available. YouTube Version For those who prefer a video version. New Connection Let’s start with a brand new Dataverse connection. When you...

Dataverse/Power BI

14th July 2022

Power Automate Child Flow

Occasionally it is useful to break your flow apart into separate flows. For this you need to create a child flow or two. There is one tweak I always forget, hence this post. Create the Child Flow When building child flows you need to follow these rules Child flows need to be built inside a solution The trigger needs to...

Flow/Power Automate

27th June 2022

Charticulator Resources

Creating custom visuals using the Charticulator in Power BI is not easy. So here are some some Charticulator resources I’ve used to skill up.

Charticulator/Power BI

7th January 2022

Charticulator Simple Custom Chart

In late 2021, the Charticulator visual was added to Power BI desktop. This post walks through creating a Charticulator Simple Custom Chart. The chart will show the drink preference split of 20 office colleagues. The steps assume you already have connected to the data. The data is available for download or direct connection here: https://hatfullofdata.blog/wp-content/uploads/2021/12/Drinks.xlsx YouTube Video It’s coming! Adding...

Charticulator/Power BI

29th August 2021

Refreshing datasets automatically with dataflows

I have a report, Open Issues, that has a Power BI dataflow as a data source. If I just use scheduled refreshes my options are limited. I could schedule the dataflow to refresh at 10am and the next slot available for the report dataset to refresh would be 10:30am. I need to be refreshing datasets automatically after the dataflow has...

Dataflow/Power Automate/Power BI

6th July 2021

How much does that report cost the business?

In nearly every business across the world, staff give reports to managers. How many people assess the report cost? The reports will show how well or badly the business is performing. Accurate reporting is important in every organisation. Management needs to be able to make data-driven decisions.

Power BI

8th June 2021

Power Query – Get Previous Row Data

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person’s previous score.

M/Power Query

4th May 2021

Power Query – Dynamic Data Source and Web.Contents()

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic Data Source. It will not refresh in the Power BI service unless you do some tricks. Fetching Data...

M/Power BI/Power Query

21st April 2021

Excel Power Query – VBA to Edit a Parameter Value

This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.

Excel/Power Query/VBA

7th April 2021

Power BI Desktop Connecting to Dataverse

Dataverse is a secure flexible data storage solution that is part of the very popular Microsoft Power Platform family. So connecting to Dataverse is an obvious request. Dataverse was previously known as Common Data Service. This post is from getting very frustrated mid-hackathon and trying to connect to Dataverse and just getting an odd error. If you want to learn...

Power BI/Power Query/Uncategorized