8th June 2021 Power Query – Get Previous Row Data In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person’s previous score. Categories Power Query/M
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
21st April 2021 Power Query – VBA to Edit a Parameter Value This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query. Categories Power Query/Excel/VBA
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
31st January 2021 Power BI – Reactor – Last Year’s Sales This post is to support my virtual session at London Microsoft Reactor on 1st Feb 2021. The session is an introduction to Power BI using sales data for 2020 from an imaginary gift shops. YouTube Recording Resources The Excel file used as the data can be found at:https://hatfullofdata.blog/wp-content/uploads/2021/01/Sales.xlsx The background image used in the demo can be found at:https://hatfullofdata.blog/wp-content/uploads/2021/01/Gift-Background.png The... Categories Power BI/Introduction
15th January 2021 Power Query – AI Insights Error AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings. Categories Power Query/Power BI
31st December 2020 Top 10 Posts and Videos in 2020 Throughout 2020 I have posted blog posts and videos covering mostly Power BI topics with some Power Apps and Power Automate posts. For me its made me learn topics properly and given me a buzz watching numbers rise. Various people have promoted blogs and videos and I cannot thank them enough. I’m am looking forward to being able to travel... Categories YouTube
14th December 2020 Power BI – Reactor – 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... Categories Power BI/Introduction
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... Categories Power BI/Dataflow