BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)
This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team
You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so rather than make it confusing I thought to change the weekly update name.
Power BI – Office 365 Adoption Content Pack
There is a new content pack for Power BI, which will leverage off of the Office 365 reporting, so that you can gain some insights into how your organization is adopting Office 365.
You can find more details here: Explore your Office 365 Adoption Data in Power BI
Power BI – Embedded Accelerator
If you are looking to use Power BI Embedded, Microsoft have a limited offer to help you get up and running.
You can find the blog post here: Power BI Embedded Accelerator
Excel – Get & Transform Updates May 2017
While the features below have been available in Power BI, it is great to see them also incorporated into Excel, as these are some really useful updates.
The first one is the auto selection of the delimiter when using the Split By, I have been using this for a while and whilst it does not appear to be time consuming it is awesome to have it pre-selected for you.
The second one is when combining files to be able to select which sample file to use from a folder.
And finally you can now connect to DB2
You can find more details here: May 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in