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