Hat Full of Data

11th July 2023

Power Automate – Get data from a Power BI dataset

Power BI datasets contain a rich useful data resource that would be really useful in a Power Automate flow. In this post we will walk through how to get data from a Power BI dataset and then email that data. This is just one example of how you could use data fetched from a Power BI dataset behind a report....

Flow/Power Automate/Power BI

7th July 2023

Power BI – Creating a Custom Smart Narrative

Power BI desktop includes the Smart Narrative visual. This will summarise a page or visual in your report for you. Often though the summary it produces is not the summary you would have written. This post will show you how to write your own custom smart narrative that updates and filters exactly the same as the standard smart narrative. YouTube...

Power BI

22nd May 2023

Power Platform Solution and Power BI – Part 3

In Part 1 we added Power BI to the Power Platform solution and then in Part 2 we added a dashboard. This is post we will embed the report into a form and filter the report to match the context of the form. For this we will use the Accounts form and filter the expenses report to only show the...

Dataverse/Power BI

20th May 2023

Power Platform Solution and Power BI – Part 2

In Part 1 we added a Power BI to a Power Platform Solution. In Part 2 we will create a dashboard and add it to the model driven app.

Dataverse/Power BI/PowerApps

19th May 2023

Power Platform Solution and Power BI – Part 1

Power BI reports can be an important part of a Power Platform solution. Microsoft has added a new feature to Power Platform Solutions to add a Power BI dataset and report. Then you can add the Power BI report in as a dashboard or as an embedded report in a form and add context filtering. Part 1 will cover adding...

Dataverse/Power BI/PowerApps

26th April 2023

Using SQL on Dataverse for Power BI

SQL (Structured Query Language) has been used to get data in and out of databases for decades. Dataverse is a database. So lets use SQL on Dataverse to fetch data into a report. This can simplify our queries and make a direct query report easier to write. YouTube Version Microsoft SQL Server Management Studio There are multiple tools available to...

Dataverse/Power BI

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