BI-NSIGHT – Power BI (Granular Tenant settings, Amazon Redshift connectivity in Power BI Service, Featured Data Stories, Availability Monitoring Publish to Web) – Excel (Get & Transform updates) – SQL Server (DAX support in Report Builder and SSMS)
Here are the weekly updates.
Power BI – Granular Tenant Settings
I can personally say that I know a few of my clients who are very happy that the Power BI team has already implemented the Granular Tenant settings for Power BI. I have to say that I am once again impressed by the Power BI Team really a great job.
I also like the fact that they have gone one step further and put in the option for “Except specific security groups”, because so often you want to allow it for almost everyone, except one group. And with their implementation they make this really easy and simple to implement.
Currently as at 16 Mar 2017, the granular settings are for the following:
Export and sharing settings
- Share content to external users
- Export Data
- Export reports to PowerPoint presentations
- Print dashboards and reports
Content pack settings
- Publish content packs to the entire organization
- Create template organizational content packs
- Use Analyze in Excel with on-premise datasets
You can read the blog post here: Announcing granular tenant settings in Power BI
Power BI – Gateway Update for March
As you can see above the Gateway for Power BI has had a whole host of updates in the March 2017 release.
In this release there is now an updated UI (User Interface), where you can now see the status of the Gateway.
You also have the options under the Service settings to restart the service, as well as change the Gateway Service Account.
In the Diagnostics section, you can now enable verbose logging, as well as export all the gateway logs to one zip file.
And finally under the Network section there is the capability to view the Local network status, as well as modify the Azure Service Bus connectivity mode.
There is also an update for the Gateway to use a FQDN instead of a list of IP addresses so that you will no longer be required to keep a list of IP Addresses.
Also if you are looking to use an Oracle data source with Kerberos configured the Power BI Gateway team are looking for candidates.
You can find the blog post details here: Power BI Gateways–March Update
Power BI – Amazon Redshift in Power BI Service
This is a informative blog post by the Power BI team where they explain how to connect, and publish your Power BI reports using Amazon Redshift.
You can find the details here: Announcing support for Amazon Redshift connectivity in the Power BI service
Power BI – Featured Data Stories
Congratulations to David Eldersveld on his featured data story, really a great way showcasing Power BI as well as the other people featured.
Next month’s feature requests are tables and matrices.
You can find the featured data stories here: Congratulations to this month’s Featured Data Stories
Excel – Get & Transform Updates
There are two updates to the Excel Get & Transform updates in the March 2017 update. The first is a new transformation which allows you to extract data values from a column. And the second is where you now have support for SQL Server Failovers when using a SQL Server database connection.
You can find the details here: March 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in
Power BI – Availability Monitoring Publish to Web
Charles Sterling from the Power BI team has a great blog post if you want to monitor the availability and ensure that your Publish to Web is working. He shows this in a few simple steps.
You can find the details here: Setting up availability monitoring for Power BI Publish to Web Results
SQL Server – DAX support in Report Builder and SSMS
In the latest release of Report Builder and SSMS (SQL Server Management Studio) there now is the ability in the query designer for DAX.
You can find all the details here: Query designer support for DAX now available in Report Builder and SQL Server Data Tools