BI-NSIGHT – Power BI (Embedded Pricing) – SQL Server 2016 (CU1, Mobile Report Publisher for July) – Excel (Power Query Update)
This week has been a good week in the BI domain.
Power BI – Embedded Pricing
As you can see from above they now have released what the pricing model will be for Power BI Embedded.
You can find the link below to view what your pricing will be based on your data center you use.
SQL Server 2016 – CU 1
This is the first release since the launch of SQL Server 2016 and the list is quite extensive in terms of the fixes.
You can view all the fixes in the link below, but I would recommend testing and then deploying as required.
Here are the details here: Cumulative Update 1 for SQL Server 2016
SQL Server 2016 – Mobile Report Publisher Update
It is great to see how Microsoft has evolved in terms of releasing updates to their product lines in a much for frequent and consistent manner. As is this case with the Mobile Report Publisher.
This update has a lot of bug fixes and optimizations. They do recommend also installing SQL Server CU1 which is in the blog post above, to ensure that the runtimes are aligned.
You can find the details here: Mobile Report Publisher update for July now available!
Excel – Power Query Update
There has been an update for Power Query or Get and Transform in Excel.
There are a whole host of updates and it is great to see that a lot of the features first appear in Power BI but quickly make their way to Excel also. And it appears that some of these features are not yet in Power BI, but I would expect them to be there soon.
Here are a few of the updates that I find relevant.
There are a whole host of new connectors and improvements for existing connectors.
They have also put in the Inline input controls for functions which makes it a lot easier to use and interact with the functions.
The support re-order the steps which is sometimes vital to get the required output.
And finally the option to get new data from within the query pane you can easily do this which makes it easier to add new data.
You can find all the details here: July 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in