Power BI RoundUp – (Power BI Preview Features in Action – Developer Update for Sept – Webinar on Power Query & M for Calendar Tables)

Welcome to another week of the weekly Power BI RoundUp, I hope you enjoy catching up on the latest content below.

Power BI – Power BI Preview Features in Action

In this blog post by Chuck (Charles) Sterling he goes into details on all the preview features that are going to be shown at the last 3 stops of the Power BI World Tour.

I went to the Sydney event and I thoroughly enjoyed it, I met some new friends, networked and learned a lot.

All the details on what will be shown is available here: See Power BI Preview Features in action at the Power BI World Tour

Power BI – Developer Update for September

As you can see above there were 3 updates this month.

The first being an update to the Capacity Metrics App for Power BI Premium workspaces where you can now not only monitor capacity, refreshes and data loads, but now there is also query metrics which is great to see if there is a long running query or a query that consumes a lot of memory and CPU.

There are now also advanced URL filtering capabilities, which often can be used to either compliment or to extend access to data for specific users or groups of people.

There is a new API where you can update the connection between cloud and on-premise data sources via the API. This is really a great improvement, as often data sources move around and with this API it makes it a lot easier to get this done programmatically.

And finally, Row Level Security now supports ASCII characters in the Username property.

All the details can be found here: Power BI Developer community September update

Power BI – Webinar on using Power Query to create Calendar tables

My friend from France will be presenting a Webinar with Chuck from the Power BI team on using Power Query to create calendar tables.

I have no doubt that this will be a great webinar and I find that there is always something to learn when watching other people, us M.

The Webinar details can be found here: 10/11 Webinar: How to use Power Query and M to create calendar tables with Tristan Malherbe

BI-RoundUp – Power BI (Developer Update for June – On-Premise Data Gateway Update for June – Securing your connection between Power BI & Azure SQL Database)

I must admit that I have been a little quiet with regards to my BI-RoundUp and it is partially due to being extremely busy working. As well as preparing for SQL Saturday Sydney and my presentation at the Business Applications Summit in Seattle at the end of July.

As they always say, the show must go on, so here is my latest BI-RoundUp

Power BI – Developer Update for June

If you are using Power BI Embedded or the developer features of Power BI, there have been some recent updates.

Embed Capabilities

You can now set the slicer values through the Javascript API. This means that when the report loads it can have the slicers pre-set.

As shown in the image above, you now can use themes in embedded dashboards.

In the playground tool (which I suggest everyone go and have a look at), it is now a lot more interactive in terms of it now being able to show “Dynamic Report Layout” and “Capture and share Bookmarks”

Automation & life-cycle management

The documentation for the Power BI REST APIs has been updated in terms of their documentation which is auto generated from Swagger files. I had a look and I do like the look of how it all works.

Power BI Embedded in Azure

There is a note that Power BI Workspace collections are going to be depreciated will no longer be available.

And finally, the Custom Visuals support report themes.

All the details from the blog post can be found here: Power BI Developer community June update

Power BI – On-Premise Data Gateway Update for June

There is an update for the On-Premise Data Gateway, which includes a lot of bug fixes and improvements.

It also includes the June version of the Mashup Engine that is currently found in Power BI Desktop.

Here is a link to the blog post: On-premises data gateway June update is now available

Power BI – Data Gateway Update for June – Securing your connection between Power BI & Azure SQL Database

If you are currently getting data from Azure SQL Database, there is an option to “Allow access to Azure Services” which allows any Azure Service to be able to contact your Azure SQL Database.

In some scenario’s this is not secure enough.

In the link below it explains how to secure the connection between Power BI and your Azure SQL Database so that it can only be accessed by the On-Premise Data Gateway.

There is quite a lot to go through, which is detailed in the blog post: Securing the connection between Power BI and Azure SQL Database

BI-RoundUp – Power BI (On-Premise Gateway Update – Developer Community Update)

Here is this week’s BI-RoundUp. I am hopeful that by this time next week the latest version of Power BI Desktop will be released!

Power BI – On-Premise Gateway Update

By far the biggest news is the capability to use Custom Data Connectors in the Personal Versions of the On-Premise Data Gateway. The Power BI Team did indicate in the blog post that support in the Enterprise version will be coming in a few months. This is fantastic to see it being made available.

There now is single sign on support using Kerberos for SAP Business Warehouse Server

And finally, there is the updated version of the Mashup Engine to the April version of Power BI Desktop

Here is a link to the blog post: On-premises data gateway April update is now available

Power BI – Developer Community Update

As you can see above for the Developer community update there now is the capability to leverage Custom Report Tooltips and the Q&A explorer.

There is now also new Azure Resource Metrics which allows for better metrics to understand how your Power BI Embedded application is working with the following metrics.

  • It will show Memory usage being used
  • It will show when there is Memory Thrashing, which is defined as when a report is trying to be run, and it needs to evict another dataset in order for your dataset to be loaded into memory. And this only applies to imported datasets.
  • It will show QPU High Utilization which shows the Query Processing units every minute on your resources when it is about 80%

There is now the capability to set up alerts on your Azure resource.

Finally, there is a new learning channel to create custom visuals with a hands-on lab.

All the details of the blog post are here: Power BI Developer community April update