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

Showing blogs 141-145 (out of 145)

How to use an unpivot transform in Power BI Desktop Query Editor

Posted by Andy Brown on 04 January 2018

If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!

Tags:
Power BI > Query editor

How to write an M formula to convert Julian dates using Power Query

Posted by Andy Brown on 08 December 2017

This short blog explains how to convert Julian dates to "normal" ones, and how the formula used actually works!

Tags:
Power BI > Query editor

A summary of the Power BI Updates going back to November 2016

Posted by Andy Brown on 19 December 2016

This blog differs from the Microsoft update summary in two ways: it omits preview and obscure changes, but goes into more detail (and gives practical examples) on mainstream updates.

Tags:
Power BI > Updates

How to create running totals or cumulative figures in Power BI Desktop

Posted by Andy Brown on 19 December 2016

There are a host of date-based functions in Power BI Desktop for producing cumulative figures, but how do you get running totals for non-date columns? This blog explains!

Tags:
Power BI > Measures / DAX

Passing parameters to SQL stored procedures in Power BI Desktop

Posted by Andy Brown on 30 November 2016

This blog summarises how to run SQL statements in a Power BI Desktop query, using dynamic SQL to pass in parameter values

Tags:
Power BI > Parameters

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