5th March 2023 Export Data from Power BI Visuals We have to accept that the business will want to export Power BI data into Excel. This post explores the options. Categories Excel/Power BI
25th February 2023 Power BI – 5 Stars SVG In the Feb 2023 Power BI Update they introduced image width in a table formatting. This means SVG images now don’t have to be square, so we can now do rectangle images. So I ported Stars SVG code I had in my Power Apps series and added this post to my Power BI SVG series For this post we are... Categories Power BI/SVG
24th November 2022 Power BI – Take Over a Dataset People change jobs, move projects so that dataset is no longer part of their job. So another accounts need to take over that dataset. Categories Power BI
22nd November 2022 Power BI – Connecting to Google Analytics Power BI has a Google Analytics connector. This blog post is to walk through building a simple report on my blog visitors. Categories Power BI
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
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 Above is a very simple example. The trigger has an input of location... Categories Power Automate/Flow
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