Power BI Archives - Page 3 of 7

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

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

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

21st March 2021

Paginated Report Resources

Important Update! On 14th Nov 2022 Microsoft announced that Paginated reports will no longer require premium capacity and can be created with a Power BI Pro license. Here is a link to the article https://powerbi.microsoft.com/en-us/blog/announcing-support-for-paginated-reports-in-power-bi-pro/ Introduction Here are resources to help you learn how to use Paginated reports. You will need a premium capacity or Premium per user license. If...

Paginated Reports/Power BI

16th March 2021

Power BI Intro – Lego Report

Intro This post is support my Introduction to Power BI using Lego data on 16th March for Virtual Power Group. This post will get longer honest! Source Files All of the data used is available from Rebrickables. To simplify creating this report I’ve put all the resources in a shared OneDrive folder

Power BI

31st January 2021

Power BI – Reactor – Last Year’s Sales

This post is to support my virtual session at London Microsoft Reactor on 1st Feb 2021. The session is an introduction to Power BI using sales data for 2020 from an imaginary gift shops. YouTube Recording Resources The Excel file used as the data can be found athttps://hatfullofdata.blog/wp-content/uploads/2021/01/Sales.xlsx The back ground image used in the demo can be found athttps://hatfullofdata.blog/wp-content/uploads/2021/01/Gift-Background.png...

Introduction/Power BI

15th January 2021

Power Query – AI Insights Error

AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.

Power BI/Power Query

14th December 2020

Power BI – Christmas Carol Text analysis

This post is to support my session at London Microsoft Reactor. The session series have all been introduction to Power BI. This session uses some Christmas Carol song lyrics and then using some AI premium tools to analyse the text. YouTube Recording Resources The Excel file used as the data can be found athttps://hatfullofdata.blog/wp-content/uploads/2020/12/Christmas-Carols.xlsx The background image and theme file...