2022-2023 Archives - Hat Full of Data

30th March 2023

Power BI – Embed a Paginated Report

Within a Power BI report you can embed a paginated report. Values can be passed to the paginated report to populate parameters. The paginated report can be exported by a report consumer. YouTube Version Paginated Report For this post we are going to use a paginated report connected to restaurant sales data. The report shows daily total dishes sold and...

Paginated Reports/Power BI

25th March 2023

Power BI – Clear all Slicers Button

The March 2023 Power BI update included a new button, Clear All Slicers. This allows you very quickly add a reset on a report for the slicers. It partly replaces the previous method explained in https://hatfullofdata.blog/power-bi-resetting-slicers-with-a-bookmark-button/ YouTube Version Adding the Button Head to the Insert ribbon and under Buttons select “Clear all slicers”. Nothing else needs to be done, although...

Power BI

18th March 2023

Power BI Business Adoption

So you’ve found Power BI, you’ve created amazing reports that answer every question your business has. Yet when you look at the stats your reports are not being looked at. People are still returning to the old spreadsheets and creating their own pie charts. What has gone wrong with your Power BI adoption? You might have adopted Power BI but...

Power BI/YouTube

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.

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...

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.

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.

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.

Dataverse/Power BI

24th September 2022

Power BI & Dataverse – Choices and Choice Column

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.

Dataverse/Power BI

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

Tag: 2022-2023

Power BI – Embed a Paginated Report

Power BI – Clear all Slicers Button

Power BI Business Adoption

Export data from Power BI Visuals

Power BI – 5 Stars SVG

Power BI – Take over a Dataset

Power BI Connecting to Google Analytics

Power BI – Switch Dataverse Tenancy

Power BI & Dataverse – Choices and Choice Column

Power BI Dataverse Connector – July 2022 Update