Here is the weekly BI Roundup

Power BI – Choosing the best licensing for you and your Organisation

In this blog post from the Microsoft Power BI team, they go through the different licensing options that are available.

They also go through the differences between Power BI Pro and Power BI Premium.

As well as give some answers to the common questions that are asked when evaluating the Power BI licensing options.

You can read more about it here: Power BI Pro & Power BI premium: Flexibility to choose the licensing best for you and your Organisation

Power BI – On-premise Data Gateway Update for October

In this month’s update includes the updated version of the Mashup Engine (Query Editor Engine).

As well as some new beta connectors (Vertica)

You can find more details here: On-Premise data gateway October update is now available

Power BI – Developer Community Update

In this blog post, there are details around new functionality and changes for the Power BI Developer.

There are some great details around Power BI Embedded, where they explain the difference scenarios on how to leverage Power BI Embedded.

I know that this can get confusing as there is Power BI Embedded with an “A” SKU, an “EM” SKU and “P” SKU. They go through this really well so that it is easy to understand which SKU to use in which scenario    .

There is now also new functionality to embed Q&A. This is great if you want to provide the Q&A functionality within your app. The interactive mode is where you use it as you would in the Power BI Service, whilst in the Results only mode where the user will only see the result of the Q&A question.

There is now added support to set new filters dynamically for the Relative Date Slicer, the Include or Exclude as well as the TopN filters.

Finally, there is an update to the Custom Visuals API which is now on version 1.8

You can find more details here: Power BI Developer community October Update

Power BI – Duplicate Workspaces using the REST APIs

This update relates to how you can duplicate as well as move content around to new App Workspaces using the Power BI APIs

They even provide a sample PowerShell script, where all that you need to do is to put in your ClientID which you get when you register an app and you are good to go.

There are some limitations currently, but what this does allow you to do, is to be able to copy content to different App Workspaces, as well as be able to change the source connections. So this can work if you have a Dev App Workspace and a Prod App Workspace, and you can transfer the content across changing the source connection from Dev to Prod.

You can find more details on how to use the APIs here: Duplicate workspaces using the Power BI REST APIs: a step-by-step tutorial