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 142)

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

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

A sample Wise Owl Power BI Desktop theme

Posted by Andy Brown on 04 June 2024

We thought it might be useful to share the theme that we use for some of our reports, with some annoations, to give you an idea of what's possible when setting default Power BI formatting

Tags:
Power BI > Formatting

Power BI Desktop Update for May 2024

Posted by Andy Brown on 04 June 2024

This month's bigger than average update sees new pivot table style matrix layouts, the emergence of modern tooltips, calculation groups and the DAX query pane from preview and a couple of other smaller changes.

Tags:
Power BI > Updates

New features in the April 2024 Power BI Desktop update

Posted by Andy Brown on 07 May 2024

The April 2024 Power BI update includes a new 100% stacked area chart visual and some minor new line chart formatting options - but still none of the big beasts lurking in preview!

Tags:
Power BI > Updates

The current state of on-object interaction in Power BI

Posted by Andy Brown on 04 April 2024

On-object interaction remains stubbornly in preview in Power BI, but it's been steadily updated since we last blogged about it, so we felt it was time for this catch-up.

Tags:
Power BI > Updates

What's new in the March 2024 Power BI Desktop update

Posted by Andy Brown on 28 March 2024

There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update.

Tags:
Power BI > Updates

Tips for using Power Automate (Web)

Posted by Sam Lowrie on 04 April 2024

Despite the new flow designer in Power Automate going live several months ago, there are still “features” (read bugs) that can cause confusion. This blog covers 5 of these quirks, showing a way to deal with each.

Tags:
Power Automate > General

What's new in the February 2024 Power BI update?

Posted by Andy Brown on 04 March 2024

The only big change in the February 2024 update to Power BI Desktop is that "Power BI Home in Desktop" is now enabled by default, but the exciting new visual calculations feature is also now waiting in preview.

Tags:
Power BI > Updates

Tricks to change column order in SQL and in Power BI

Posted by Andy Brown on 04 March 2024

Two little tricks to change the order of columns in SQL Server Management Studio and Power BI Query Editor, which (to our shame?) we've only just discovered.

Tags:
SQL > Selecting data Power BI > Query editor

A deep-dive into creating and using Azure Map visuals in Power BI

Posted by Andy Brown on 04 March 2024

The Azure map visual has been an official part of Power BI now for nearly a year, and the initial teething problems have now been ironed out. This blog shows how to use the Azure maps visual, and explains why you don't now need to use any of the other map visuals in Power BI.

Tags:
Power BI > Maps

We've updated our Power BI courseware after a two-year gap

Posted by Andy Brown on 01 March 2024

Power BI is a nightmare to teach, as it keeps changing! Our policy is to update our courseware roughly every 18-24 months; this blog contains details of our latest huge update, and how it will affect delegates on our Power BI courses.

Tags:
Power BI > Updates

Visual Calculations in Power BI

Posted by Andrew Gould on 23 February 2024

The February 2024 update to Power BI has an interesting new preview feature: visual calculations. These allow you to create DAX calculations within individual visuals in a report. This blog shows why that's useful!

Tags:
Power BI > Measures / DAX

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