BY TOPIC▼
POWER BI BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Power BI blogs from Wise Owl (page 1 of 8)
Showing blogs 1-20 (out of 151)
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.
Power BI Desktop update for May 2021
Posted by Andy Brown on 19 May 2021
May's update to Power BI Desktop is a big one, encompassing new ways of viewing models, tables and fields, a new text box, smart narratives (to explain data) and a new anomaly detection feature (to explain exceptions).
Details of the Power BI Desktop Update for April 2021
Posted by Andy Brown on 28 April 2021
The April 2021 update to Power BI Desktop makes it easier to load text, CSV, JSON and Excel files and includes a wider range of shapes, with more drawing effects
Solving FAILED TO DECRYPT CREDENTIALS message when running Power BI
Posted by Sam Lowrie on 20 April 2021
Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!
Power Query Online now supports flow diagrams!
Posted by Andy Brown on 24 March 2021
A life-changing (or at least job-changing) new software update from Microsoft - you can now see a visual view of data flows in Power BI (at least in the online version, anyway).
Power BI Desktop - March 2021 Update
Posted by Andy Brown on 24 March 2021
There are two tiny changes in the March 2021 update - X-axis constant lines and a couple of tweaks to DAX - but still the big logjam of changes remains in preview.
Colouring the table row for a selected item in Power BI
Posted by Andy Brown on 22 March 2021
How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!
Changes to Power BI in the February 2021 update
Posted by Andy Brown on 26 February 2021
After no update in January, February sees just a couple of small changes to Power BI, but there's a big logjam building up in preview.
Showing DAX Studio and Tabular Editor as external tools in Power BI
Posted by Andy Brown on 23 February 2021
Power BI automatically creates an External Tools ribbon when you install the Power BI, Tabular Editor and ALM Toolkit add-ins.
DAX.DO - a replacement for DAX Studio?
Posted by Andy Brown on 22 February 2021
The legendary Marco Russo has launched a new web-based DAX editor, but can it compete with or even replace DAX Studio?
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 ... !