BY TOPIC▼
POWER PLATFORM BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
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.
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?
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.
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!
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.
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.
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.
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.
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.
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!
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.
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!
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!
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!
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.
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.
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.
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 ... !