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. Categories Power BI/Dataverse/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... Categories Power BI/Dataverse/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... Categories Power BI/Dataverse
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... Categories 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... Categories Power BI
18th March 2023 Power BI Adoption in Your Business 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... Categories 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. Categories 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... Categories 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. Categories 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. Categories Power BI
