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 2 of 8)

Showing blogs 21-40 (out of 154)

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

Converting UK postcodes to latitude and longitude in Power BI

Posted by Andy Brown on 09 February 2024

A series of steps that you can follow to convert UK format postcodes into latitude and longitude data for use in Power BI Desktop visuals.

Tags:
Power BI > Maps

The December 2023 update to Power BI Desktop

Posted by Andy Brown on 31 January 2024

This update includes lots of updates to the formatting of bar/column charts, even more data label formatting options and better clustered bubble chart formatting for Azure Maps.

Tags:
Power BI > Updates

Plans for our Power BI courseware for 2024

Posted by Andy Brown on 31 January 2024

It's time to bite the Power BI bullet and revamp our courseware (our last update was nearly two years ago).

Tags:
Power BI > Updates

Changes to Power BI Desktop in the November 2023 update

Posted by Andy Brown on 11 December 2023

Although the main innovations in this update are in preview, two of them are turned on now by default: button slicers and reference labels for cards. We also can't resist the temptation to show the new DAX query view, even though it's still very much in preview only.

Tags:
Power BI > Updates

An introduction to calling Microsoft Graph within Power Automate

Posted by Andy Brown on 30 November 2023

Microsoft Graph is the (strange and misleading) name for the gateway provided by Microsoft to get at all of the things stored in your 365 cloud (emails, files, users, groups, teams and much more). This tutorial explains what Graph is in more detail, and shows how you can call Graph from within Power Automate flows.

Tags:
Power Automate > Microsoft Graph

Exporting and importing flows in Power Automate

Posted by Andy Brown on 22 November 2023

How to export a flow from one account and import it into another in Power Automate

Tags:
Power Automate > General

Writing a flow to delete all of your flows

Posted by Andy Brown on 22 November 2023

After every training course I have to manually delete every flow from every delegate's computer. This takes ages, and stresses me out. There must be a better way ... mustn't there? Maybe I should write a flow to delete all my flows?

Tags:
Power Automate > Creating flows

The new flow designer in Power Automate

Posted by Andy Brown on 22 November 2023

The new flow designer in Power Automate is now turned on by default, which isn't necessarily a good thing, as this blog explains.

Tags:
Power Automate > General

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