This page has 1 thread | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Power platform blogs from Wise Owl (page 1 of 8)

Showing blogs 1-20 (out of 153)

Sending Christmas emails automatically with a Power Automate flow

Posted by Andy Brown on 09 December 2024

Now that Microsoft have finally ironed out most of the bugs from the new flow designer in Power Automate, we thought we'd share this blog on how to automate your email Christmas card procedure!

Tags:
Power Automate > Creating flows

Power BI Desktop updates for November 2024

Posted by Andy Brown on 06 December 2024

This month sees a few new preview features (of which we've chosen to highlight list and text slicers), but only two release changes: paths in Azure maps, and the ability to create new measures in DAX queries.

Tags:
Power BI > Updates

New Power BI Desktop skills test

Posted by Andy Brown on 06 December 2024

Not before time, we've updated our Power BI Desktop skills test to the latest version. It's interesting to look back at the original test to see just how much has changed!

Tags:
Power BI > General Miscellaneous > Skills tests

The Power BI Core Visuals Vision Board

Posted by Andy Brown on 06 December 2024

A new single page summarising planned improvements to visuals and other display items in Power BI Desktop

Tags:
Power BI > Visualisations

Import custom icons into Power BI

Posted by Sam Lowrie on 02 December 2024

Icons can add a little extra something to your reports. Working out how to do this using JSON files is tricky and in this blog we will cover how!

Tags:
Power BI > General

Our Power BI blogs added recently and not referenced elsewhere

Posted by Andy Brown on 06 November 2024

We've silently added a fair few blogs on Power BI in the last couple of months - this short blog gives a useful index to them.

Tags:
Power BI > General

Power BI Desktop - Updates for October 2024

Posted by Andy Brown on 05 November 2024

You can now create data-bound reference layers in Azure maps, document your model's measures, tables and columns using the INFO.VIEW function in DAX, format chart markers within inches of their lives and apply dynamic formatting using DAX.

Tags:
Power BI > Updates

Connecting to the UK Bank Holiday API

Posted by Sam Lowrie on 31 October 2024

Pull through the official list of Bank Holidays in the UK.

Tags:
Power BI > Dates and calendars

Conditionally formatting a Percent of grand total column in Power BI

Posted by Rick Gould on 22 October 2024

Although Power BI allows you to display values as a percent of the grand total, you can't conditionally format this directly. Fortunately, you can use a measure to solve the problem.

Tags:
Power BI > Formatting

Change multiple measure definitions at once

Posted by Sam Lowrie on 30 September 2024

Updating a measure definition is easy but what happens when you have 200 to update? This blog guides you through using the Dax Query View to achieve this.

Tags:
Power BI > Measures / DAX

Power BI Desktop update for September 2024

Posted by Andy Brown on 26 September 2024

This month Power BI Desktop gets a new dark mode! Visual calculations and visual level format strings have also been turned on by default (although both remain in preview, strangely).

Tags:
Power BI > Updates

Pull data from a Power BI table using Power Automate

Posted by Sam Lowrie on 23 September 2024

Use Power Automate to pull data from Power BI using a DAX query.

Tags:
Power BI > Data sources Power Automate > General

Adding a last refresh date to Power BI reports

Posted by Sam Lowrie on 09 September 2024

Add report refresh date

Tags:
Power BI > Data sources

Importing web tables by example in Power BI

Posted by Andrew Gould on 07 September 2024

Not every set of data you want to import from a web page is considerate enough to exist as an HTML table. Fortunately, you can give examples of the information you want to import to have Power BI infer a table from the data on the page.

Tags:
Power BI > Data sources

A model example of how to use Power BI - Marie's pilot log

Posted by Andy Brown on 05 September 2024

If you're a qualified pilot (but also a bit of a data nerd) how do you keep track of your flights? With a Power BI report, of course!

Tags:
Power BI > General

Power BI Desktop Updates for July and August 2024

Posted by Andy Brown on 05 September 2024

Most of the changes in the July and August updates to Power BI are either too insignificant to merit a write-up here or else are for features in preview. For most report-writers the ability to document DAX measures is the only change which will make much difference in these two updates.

Tags:
Power BI > Updates

Dynamic Measure Formatting

Posted by Sam Lowrie on 09 September 2024

When using more complex measures there may be a need for each to be formatted differently. This blog shows you how to use the dynamic formatting measure feature.

Tags:
Power BI > Measures / DAX

Power BI Drill through with multiple categories

Posted by Shaun Wantling on 09 July 2024

A method for using Drill through in Power BI with multiple categories.

Tags:
Power BI > Bookmarks and filters

A modest update notable only for the roll-out of Home in Desktop

Posted by Andy Brown on 20 June 2024

This month's update to Power BI Desktop adds some seriously arcane functions to DAX, but it's the roll-out of the Power BI Home feature which most people will notice.

Tags:
Power BI > Updates

A central resource for all things M

Posted by Andy Brown on 04 June 2024

The PQ How site contains both a reference guide to the M language and lots of links and resources for articles which will help you to learn it.

Tags:
Power BI > Query editor

This page has 1 thread

Add a new post

From:	duggie
When:	23 Jun 18 at 07:59

Hi Andy,

I'm a little confused about Power BI. Looking at your videos, it seems Power BI is a collective term for PowerPivot, Power Query, Power Map, etc.

However, googling Power BI, I see this, where the video shows a completely independent tool aimed at creating dashboards and reports, so can you please clarify what is Power BI? Thanks.

From:	Andy B
When:	23 Jun 18 at 16:14

Microsoft haven't helped with their naming convention! They keep changing what Power BI refers to. Here's where we're at now ...

Power BI is a standalone desktop product, previously known as Power BI Desktop. You can use these to create reports, and publish them to the web.

PowerPivot runs within Excel, and allows you to link different data sources together to create a data model, and use this as a basis for pivot tables. PowerPivot used to be one of the Microsoft Power BI tools, but they seem to have quietly dropped this title.

So when Microsoft refer to Power BI, they now refer to creating reports in the standalone Power BI application, perhaps using Power BI Pro, and publishing these to the Internet.

Hope that's clear ... !

Add a new post

BY TOPIC