Hat Full of Data

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

Introduction/Power BI

28th November 2020

Power BI Dataflow – Create Dataflow from Export

There are times when you need to copy a dataflow from one workspace to another workspace. Power BI service provides a simple way to export the definition as a json file and then import. YouTube Version Export dataflow as json file In the workspace of the original workspace, click on the three dots next to the dataflow and select Export...

Dataflow/Power BI

23rd November 2020

Power BI Dataflow – Refresh History

Find out which entity took the longest or caused the error in a refresh by looking at the refresh history of a dataflow in Power BI.

Dataflow/Power BI

21st November 2020

Power BI Dataflow – New Diagram View

The new diagram view feature introduced Nov 2020, produces a brilliant diagram of how the queries and parameters relate within the dataflow.

Dataflow/Power BI

21st November 2020

Power BI Dataflows – Endorsement as Promoted and Certified

Inform your users as to which dataflow to use by using Endorsement. This allows you to label a dataflow as promoted or certified.

Dataflow/Power BI

15th November 2020

Power BI – Tea & Biscuits Session at London Reactor

This post is to support my virtual introduction to Power BI session for London Reactor on 16th November 2020.

Power BI/Power Query

9th November 2020

Power BI – Scheduled Refresh for your Dataflow.

Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it.

Dataflow/How to/Power BI

3rd November 2020

Power BI – Create a Dataflow for Reusable Transforms

Create a Dataflow is a great way to give your report writers reusable transforms that doesn’t require data logins for every report writer.

How to/Power BI

12th October 2020

Power BI – Analyse Titanic Data with AI Visuals

This is a post to support my session at the Reactor on 12th October 2020. The session was aimed at newcomers to Power BI and the AI visuals. Below is a link to the video on Reactor’s YouTube channel Data Sources The session uses 2 data sources, the passenger list for the Titanic and an Excel file to add some...

How to/Power BI/YouTube

2nd September 2020

Power BI Introduction – Weather Report Resources

Here are links to resources I used for the Power BI Introduction session at London Reactor on Wednesday 2nd September 2020.

Power BI