The April 2019 update to Power BI has many good features, as this blog explains
Part eight of a nine-part series of blogs

The April 2019 update to Power BI introduces a new concept: the ability to make the value of a property dynamic. Other welcome new changes include M Intellisense, data profiling in query editor and cross-report drill-down.

  1. The April 2019 Update to Power BI Desktop
  2. Conditional titles for visuals and conditional URLs
  3. Intellisense in the M Query Editor Language
  4. Data profiling in Query Editor
  5. Cross-report drill-through
  6. Fuzzy merging
  7. Power BI Dataflows
  8. Other changes in the April 2019 update (this blog)
  9. Power BI features waiting in preview, as of April 2019

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 18 April 2019

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Other changes in the April 2019 update

The following is a list of changes which didn't justify an article of their own, but which some people may find interesting.

The Python visual is now official

... and also ugly!  Here's the icon:

Python visual

Couldn't they have had a picture of a snake? Like the one just found in the Everglades?

 

For any Pythonistas out there, here's what you get if you drag a couple of fields onto this visual:

Python visual with fields

Since I don't know Python, I confess that this means nothing to me!

A PDF connector

This is very clever.  Here's a PDF I was sent by Dell this week.  It's a quote for some laptops, so let's see if I can load the data into Power BI:

PDF data

A fairly typical PDF table that you might want to load.

I'll use the new PDF connector:

PDF connector

The PDF connector is of type File.

 

The results are pretty good.  Whoever knew a PDF file could contains so many tables of data!

Tables in PDF file

This is probably the table I'd want to load, showing the parts of the laptops I'm getting a quote for.

And then I'm just a hop, skip and a jump from tidying the data up in Query Editor and presenting it in a Power BI table.

Synonyms in Q&A

Suppose that in the new(ish) Model View, I've said that a shopping centre is synonymous with a shopping mall:

Synonym for field

You can set a synonym for any field, but here I've made my field name more familiar to US readers.

 

The Q&A facility will now recognise partial synonyms:

Partial synonym

I've only had to type Sh to bring up Shopping mall.

If we took a vote for this month's least interesting update, surely this would win?

New DAX function

There's a new DAX function in town:

ALLCROSSFILTERED function

To quote Microsoft: this function can be used to remove filters on a table from other tables across direct or indirect many-to-many relationships.

Paginated report builder

This mysterious new software release had us excited:

The Power BI Report Builder icon

The icon - is this a new application completely?

 

When starting, the application looks very like Power BI Desktop:

Power BI Report Builder - loading

Loading Power BI Report Builder ...

However, what you get is just a version of Report Builder, the baby sibling to SQL Server Reporting Services:

Report Builder

This is identical to Report Builder!

The idea is that when using Power BI Service you can click on a link to download the app, and then use it to create paginated reports (ie SSRS ones).

This blog has 0 threads Add post