1st November 2022 Power BI – Switch Dataverse Tenancy Occasionally you need to change to point to a different tenancy which means changing a connector to switch Dataverse tenancy. Categories Power BI/Dataverse
24th September 2022 Power BI & Dataverse – Choice Columns When a choice column is created in Dataverse, you can create a custom list of values which you want in Power BI as a table. Categories Power BI/Dataverse
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... Categories Power BI/Dataverse
27th June 2022 Power BI 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. Categories Charticulator/Power BI
7th January 2022 Power BI 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... Categories Power BI/Charticulator
29th August 2021 Refreshing Datasets Automatically with Power BI 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 need to be refreshing datasets automatically after the dataflow has finished so my reports are up to date as soon as possible to avoid a situation where I schedule the dataflow to refresh... Categories Power BI/Dataflow/Power Automate
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. Categories 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... Categories Power Query/M/Power BI
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... Categories Power BI
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... Categories Paginated Reports/Power BI
