Hat Full of Data

22nd August 2020

Power BI – Import Text Using Examples

Import text using examples was introduced in the 2020 August update for Power BI. It writes the Power Query steps to transform a non-tabular text file into a table.

Categories Power BI/Power Query

15th August 2020

Power BI – Q&A Synonyms Update

Q&A allows report readers to ask questions regarding the report data. Natural language interpretation can be improved by using Q&A synonyms.

Categories Power BI/Updates

6th August 2020

Thank You! One Year On

At the end of July 2019 I decided to posting more regularly to my own blog and on the 5th August 2019 I posted my first video on YouTube. This post is to say thank you to anyone reading this and any other post or watching a video. I remember being highly amused when I got 25 subscribers and when...

Categories YouTube

1st August 2020

Power BI – Endorse a Dataset as Promoted or Certified

Connecting to an existing dataset is highly recommended if possible. To encourage report builders to select the right datasets you can endorse a dataset.

Categories Power BI/How to/YouTube

25th July 2020

Power BI – Gradient Legends

The July 2020 update to Power BI introduced a new feature of Gradient Legends to help annotate the colours used in a colour scale conditional formatting.

Categories Power BI/How to/Updates/YouTube

15th July 2020

Power BI – Introducing Sync Slicers

How many reports have duplicate slicers across the pages and the report reader has to re-apply the slicer values on each page? Sync slicers fixes the problem.

Categories Power BI/How to/YouTube

10th July 2020

Power BI – Personalize Visuals

The May 2020 update for Power BI includes the option for a report reader to personalize visuals and save the changes as a bookmark.

Categories Power BI/Updates/YouTube

22nd June 2020

Reactor – Power BI Introduction Resources

This post is to support my virtual session at London Reactor on 22nd June. It will include the recording and links to the data source and the final Power BI Report. Link to Recording will go here…. Data Used at Reactorand Final File Data in a single Excel File Final PBIX File Links to great Resources

Categories Power BI

3rd June 2020

The Anxious MVP

The buzz of being nominated for an MVP is great, adding the community activities you do with passion all working towards what is built up to being a huge a goal. Hopefully eventually you get the email we’ve all seen in social media to say you’ve been awarded an MVP. You put out the messages saying how humbled, honoured, happy...

Categories Community

31st May 2020

Power Apps – Embed a Power BI Chart

This post covers how to embed a Power BI chart from a published report into a Power App, handling a tile that doesn’t appear and then filtering the embedded chart.

Categories PowerApps/How to/Power BI/YouTube