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

Showing blogs 1-20 (out of 160)

Using the CalendarAuto function effectively in Power BI

Posted by Andy Brown on 24 November 2021

This blog shows how to generate a table which includes not only all of the dates in your data model, but also a range of aggregator columns such as financial year and month name for reporting purposes.

Power BI November 2021 Update

Posted by Andy Brown on 23 November 2021

This month's update is a biggie, with the introduction of a page navigator and a bookmark navigator, but it's the new formatting pane waiting in preview which will really changes people's lives.

Tags:   Power BI | Updates

A Power Automate flow to send Xmas gift emails automatically

Posted by Andy Brown on 18 November 2021

Tired of doing repetitive tasks at Christmas? This blog shows you how to create a Power Automate Desktop flow to send emails out to your nearest and dearest programmatically, with each email including instructions on how they should use the gifts they've been given.

Introducing Power Automate Desktop

Posted by Andy Brown on 18 November 2021

Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?

Tags:   Power Automate | General

Changes for the October 2021 Power BI Update

Posted by Andy Brown on 28 October 2021

There are virtually no changes in this month's update, but this blog does include details of two new features which slipped through previous monthly update nets: persistent filters and personal bookmarks.

Tags:   Power BI | Updates

Using personal bookmarks to persist filters

Posted by Andy Brown on 28 October 2021

In Power BI Service you can now create personal bookmarks to retain any changes you've made to filtering for a report.

Persistent report filters in Power BI

Posted by Andy Brown on 28 October 2021

Consumers of your reports can alter filters, but you can change an option to prevent these changes persisting for other users.

Sharing Power BI Reports using Teams

Posted by Andy Brown on 28 October 2021

You can add a tab for a Power BI report within a Teams channel, and also share a report from Power BI Service within Teams - this blog shows you how to do both these things!

Tags:   Power BI | General

September 2021 Power BI Update

Posted by Andy Brown on 28 September 2021

The September 2021 update to Power BI introduces even more features for customising buttons, a Power Automate connector and line chart series labels, along with a few other small changes.

Tags:   Power BI | Updates

Power Apps causes 38 million records to be exposed online

Posted by Andy Brown on 31 August 2021

An investigation from security company UpGuard has revealed that many major US companies have exposed user data online through badly configured Power Apps applications.

Tags:   Power Apps | General

Changes to Power BI Desktop for August 2021

Posted by Andy Brown on 31 August 2021

This month sees individually customisable shapes and further refinements to the X axis constant line, among other improvements to Power BI Desktop.

Tags:   Power BI | Updates

The Magic of the Power Query SHARED Global Environment

Posted by Andy Brown on 26 July 2021

How to use the #shared keyword to bring up a list of all of the M functions in Power BI Query, and then use this list to create your own help table or even your own function.

Tags:   Power BI | Query editor

Power BI July 2021 Update

Posted by Andy Brown on 26 July 2021

This month's update sees the launch of small multiples, a range of new dynamic format properties and the roll-out of sensitivity labels.

Tags:   Power BI | Updates

Showing Small Multiples in Power BI charts

Posted by Andy Brown on 26 July 2021

Small multiples are mini-charts shown in a two-dimensional grid, with each chart showing the state of play for a different field's value. After a number of improvements small multiples have finally emerged from preview!

Tags:   Power BI | Visualisations

5 short tips for Power BI

Posted by Sam Lowrie on 19 July 2021

Sometimes our Owls come across little titbits that aren't big enough to count as a full meal. Instead we bide our time and create a smorgasbord of little bites for you to feast on. With that in mind, here are 5 Power BI tips that you might not know.

Tags:   Power BI | General

Power BI Reports vs. Paginated Reports

Posted by Andrew Gould on 19 July 2021

Confused about the difference between Power BI Reports and Power BI Paginated Reports? Allow this blog to clear up the confusion!

Tags:   Power BI | General

Power BI Channels you should watch

Posted by Sam Lowrie on 01 July 2021

There are many great resources for learning Power BI, and so many of them are completely free! Level up your BI skills with some of the best. Here Sam covers some of his favourite BI channels. You even get a glimpse behind the curtain to see other channels he watches!

Tags:   Power BI | General

Useful short-cut keys for use in the DAX formula editor

Posted by Andy Brown on 30 June 2021

DAX contains a number of incredibly useful hidden short-cut keys, allowing you to move lines, comment code and much more!

Tags:   Power BI | Measures / DAX

Power BI Desktop update - June 2021

Posted by Andy Brown on 29 June 2021

This update only includes a couple of tweaks for charts, although more excitingly the paginated reports visual is now in preview.

Tags:   Power BI | Updates

Creating picture charts in Power BI using the Infographic Custom Visual

Posted by Andy Brown on 19 May 2021

Want to use your pet's picture for a column chart? This blog shows how to create stacked picture charts in Power BI using the powerful Infographic custom visual.

Tags:   Power BI | Visualisations
This page has 1 thread Add post
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.

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 ... !