BI-NSIGHT – Power BI (Community Blog Highlights – Power BI Germany – Latest Updates for Power BI Desktop – How Microsoft uses Power BI to run its Cloud Business – Connecting Datasets to Power BI Service) – SQL Saturday Brisbane (I’m presenting) – SQL Server (SQL Server 2017 – DAX Editor for SSDT – New Get Data Experience for SSDT)

I thought that this might be a quieter week, but once again there are a whole host of updates from Power BI updates, to SQL Server 2017 announcements. Quite a bit to read through so I hope you enjoy it.

Power BI – Community Blog Highlights

I actively participate in the Power BI Community, as well as when I feel like I have something meaningful that will also contribute to the Power BI Community get it published onto the Power BI Community Blog. And in this month’s highlights I am thrilled to have my latest blog post as part of the highlight.

The other posts are below:

Power BI – Infographic for Power BI from an end to end perspective, by Gilbert Quevauvilliers

Design Pattern – Groups and Super Groups!, by Greg Deckler

Get Your Own Power Query Editor using Notepad++, by Lars Schreiber

What I Learnt Building Power BI Custom Visuals, by Chamara Ranasinghe

A Simple and Fun Guide to Microsoft Flow and Power BI, by Ruth Pozuelo

The Ultimate Waterfall Chart , by Klaus Birringer

Power BI – Germany

I know from personal experience that having your data reside in the same country you are working from means a much easier and broader adoption of Power BI. Now for people living in Germany they are able to fully comply with all the requirements in terms of having data hosted within Power BI.

As a side note I also saw that Microsoft is the first company to offer a data centre in South Korea which is great to see.

You can find the blog post details here: Experience your data with Power BI Germany and meet your compliance and regulatory needs

Power BI – Latest Updates for Power BI Desktop

I recently came across this link below, which always will point to the latest details with regards to the Power BI Desktop.

I would suggest bookmarking this page, to ensure you always have the latest information available.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/

Power BI – How Microsoft uses Power BI to run its Cloud Business

This is a really interesting blog post where they details how Microsoft uses Power BI to monitor Power BI as well as all the other BI components that fall under James Phillips. What amazes me is that for each of the KPIs shown in the screen there is a General Manager responsible for that particular product.

What this also shows is how to build an effective KPI dashboard which is easy to view and know when something is not going as it should.

You can find the interesting read here: How Microsoft uses Power BI to run its growing cloud business

Power BI – Connecting to the dataset in the Power BI Service

In this blog post from the Power BI team they go into some details around how and why you would want to use the Power BI Dataset in the Power BI Service.

One thing that I found interesting and I guess I had never thought of is that you can now connect to ANY dataset that has been published to the Power BI Service. This includes datasets from Curated Content Packs which makes the development experience that much easier.

You can find the details here: Connecting to datasets in the Power BI service from Desktop

SQL Saturday Brisbane – I’m Presenting on Power BI Real World Tips and Tricks

I am so excited that I will presenting for the first time at SQL Saturday Brisbane on Saturday 27 May 2017.

The session details are Power BI Real world tips and tricks. Below is the session excerpt:

Out in the real world, people are starting to use Power BI to gain insights into their data that were previously never seen. With Gilbert currently working full time in Power BI projects, he has first hand experience on how to leverage Power BI in work place.

By providing real world, real working examples I plan to show how some simple tips and tricks can make their reports and dashboards amazing and insightful. This will be an interactive and demo rich presentation.

The real world tips will cover the following sections of Power BI:

  • Query Editor
  • DAX
  • Visuals
  • Power BI Service

You can register for SQL Saturday here: SQL Saturday Brisbane – 27 May 2017

SQL Server – SQL Server 2017

I personally think that with the release date of SQL Server 2017, that Microsoft is looking to continue what it has been doing with the combination of experience with Power BI and deploying updates to Azure SQL Server.

This is allowing them to deploy and implement changes to SQL Server in at a faster pace. I do also personally think that with the deployment and testing with Azure, they can test real world scenario’s with a diverse environment to make sure that it works as expected. This allows them to then take all these learnings and put it into an On-Premise Solution.

You can find the details here: SQL Server 2017

SQL Server – DAX Editor for SSDT

It was just a matter of time before the DAX editor became part of SSDT (SQL Server Data Tools) and now it is finally here.

This will no doubt make the creation and editing of measures and calculated columns a lot easier and quicker to develop.

They are planning to have Intellisense as well as Code Formatting in future releases

You can find the details here: Introducing a DAX Editor Tool Window for SSDT Tabular

SQL Server – What’s new in SQL Server 2017 for Analysis Services

As you can see above there have been a whole host of enhancements for Analysis Services in SQL Server 2017.

The new Object-Level Security to secure more data looks really interesting in that you can now also secure it on a column level. As well as performance improvements for the developer experience, which I personally know in the past at times was particularly slow.

Along with improvements to the DMV’s, similar Date Hierarchy implementations that are currently in Power BI.

As well as other improvements you can read about here: What’s new in SQL Server 2017 CTP 2.0 for Analysis Services

SQL
Server – New Get Data Experience

With the new release of SSDT they have updated the Get Data Experience for SSAS models with level 1400.

It appears that they are looking to align with what is currently being implemented in Power BI, which is fantastic to see because it will mean a more consistent developer experience.

They are continuing to add more data sources with each release.

You can find all the details here: New Get Data Capabilities in the GA Release of SSDT Tabular 17.0 (April 2017)

BI-NSIGHT – Power BI (Publish in Web App, Enterprise Gateway GA, Desktop Update, Troux Content Pack, New Visuals) – SQL Server 2016 (CTP3.3, eBook, R)

So from last week to almost having nothing to talk about, to this week having a whole host of updates.

Just to quickly mention I attended the first local Power BI User Group meeting in Brisbane this evening ( QLD Power BI User Group ), and it had a really great turnout, along with some great content for the first user group. I have no doubt that it will grow from strength to strength.

So let’s get into the details there is a lot to cover here.

Power BI – Publish in Web App

This has been one of the most requested things that have been voted on. And it is great to see that they have listened again to what the people and users are asking for and have delivered it.

There are a few things to be aware of is that once you embed it into another application all your security is not valid.

Along with this currently due to it being in preview there might be an additional cost to have this capability. Which I can understand in a way because they are actually providing this outside of Power BI, and by making it available for anyone to interact, that means that there are things that are happening within the cloud that needs to be accounted for.

You can find out the details here: Announcing Power BI “publish to web” preview

Power BI – Enterprise Gateway General Availability

This is something that I have covered in the past, and it is great to see that they have incorporated all the features into one product.

This means it will make it easier to install, configure and get people using your on premise data. As you can see that this is something that I am already using and will be a great feature going forward.

Also the ability to handle failovers, as well as having the performance counter information will be great for viewing what is happening as well as the performance of the gateway.

You can find out the details here: Announcing General Availability of Power BI gateway for enterprise deployments

Power BI – January Desktop Update

This was announced last week, and there are a whole host of updates in the Power BI Desktop. I will go through a few ones here that I think are really important.

As you can see above, you can now add borders as well as Cartesian charts’ plot area.

Along with this, I really liked that you can now refresh data in individual tables, because sometimes in the past you did not want to refresh everything including your largest table.

And finally I see that they are still making performance improvements and cross rending is great. It has always been a fast visualization, but to make even that little bit faster means that everything will be that much quicker and who does not like speed?

You can find details here: Power BI Updates This Week: New Report Authoring Capabilities

Power BI – Troux Content Pack

This is yet another content pack, and if you are an existing Troux customer then I am sure that using Power BI will give you some great insights into your technology investments. Which will help you understand your data and how best you can leverage on your information.

You can find the details here: Explore your Troux data in Power BI

Power BI – New Custom Visuals

As you can see above there have been 3 new great visuals that have been released. And to me they are concentrated around mostly financials, which is great to see.

You can go here to see all the visuals: Power BI Custom Visuals

SQL Server 2016 – CTP 3.3

It was a surprise to see that they have released CTP 3.3 and most of the updates are around SSRS and SSAS Tabular.

It is great to see that now as per the visual above you can add your own favorite reports to your SSRS view of the world. Which I think is something that is so simple, but at the same time so valuable.

Along with this is the details and updates for SSAS Tabular.

It is really good to see that you can now create calculated columns in Direct Query mode. As well as applying Row Level security in Direct Query mode also. As I know personally in the past I did not implement Direct Query mode, due to the limitations, which now they have resolved.

It is good to see that they are adding a lot of updates and features for Business Intelligence to SQL Server 2016.

You can find details around SQL Server 2016 CTP3.3 here: Access your favorite KPIs and reports with SQL Server 2016 CTP 3.3

And then if you want to find out the details around SSAS Tabular you can find that here: What’s new for SQL Server 2016 Analysis Services in CTP3.3

SQL Server 2016 – eBook

This is an update from the original eBook, and there is a lot of great content in here, especially if you are not fully aware of what is coming in SQL Server 2016.

There are two versions for desktop and mobile.

You can find information about the eBook here: Free eBook: Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2

SQL Server 2016 – R


As you can see above R has come a long way, and is a great tool to use if you have the specific requirement.

The screenshot above was from a presentation by Jen Underwood. And there is some really valuable information in this slide deck.

If this is something of interest to you, you can view the slide deck here: Microsoft R Server and SQL Server R Services

BI-NSIGHT – Power BI (Q&A for SSAS Tabular, Weekly Service Update, Lithium Content Pack, Mobile App for Windows 10 Mobile) – Azure (SQL Server Virtual Machines) – Power BI and Leveraging the Cloud

Even though I think a lot of people took time off over the Christmas period it seems that the Power BI team at Microsoft was full steam ahead.

Which is a great thing to come back to work and have all these updates and new things to look into.

Power BI – Q&A for SSAS Tabular

The reason for me starting with this, is that currently I really enjoy the capabilities that you have when using Q&A within the Power BI service.

My only gripe was that when I am directly connecting to an On-Premise SSAS Tabular database I was not able to use Q&A. And often the On-Premise SSAS Tabular databases are where a significant amount of time and development has been spent getting it with all the required information.

And don’t get me wrong it is great to connect directly and create reports and have real-time queries running.

But in order to really showcase what it is capable of until now I felt that Q&A was the missing piece. And it is great to see that this is something that they have started working on. And I have no doubt that this will be a welcome feature and something that I will put to use as soon as it is available.

You can find out about it here: Add Q&A capability for datasets based on Analysis Services Tabular Models

Power BI – Weekly Service Update

This past week’s update was once again a big update with a whole host of additions.

Once again I am only going to highlight what I think is significant from the list below.

Dashboards

Collaboration

Reports

Connectivity 

Excel Reports

Other

With regards to the Dashboard and Reports section I do think that the ability to export the data is really something that people have been asking for, for a long time. And it does give the report consumer the ability to use and interact if required with the raw data.

How often do we hear the question, can we export this to Excel? Well now we can from Power BI!

Adding the image to Text box as a Widget is another great addition. I think more so, that this now means that there will be the ability going forward for more Widget type of applications to be added into the dashboards. Which can only lead to some really great ideas and implementations on the dashboards.

Printing and knowing the last time a Dashboard tile was refreshed is also very welcome. This gives the users to take the information to a meeting, or to showcase the dashboard. As well as quickly identifying if the data is current and up to date.

Under connectivity it is great to see that you can now connect to Files on SharePoint Team sites. I know in a lot of companies where they utilize SharePoint team sites for all their documentation and related files. And they are often working directly with those files. Now with this capability it means that as soon as the file gets update, within the timeframe the report will be updated also.

Under Excel it is great to see that you can now open and pin the Excel Charts to a dashboard. This is very welcome as often your chart tells a very interesting story and instead of having to try and re-create it, you can use all the hard work that has already been done.

You can read all about it here: Power BI Service Update

Power BI – Lithium Content Pack

Another week another great content pack. This week it is Lithium, which enables brands and customers using social media to get the answers that they need as well as share their experiences. Which in turn leads to more revenue.

You can find out the details about it here: Analyze your Lithium community data in Power BI

Power BI – Mobile App for Windows 10 Mobile

This is without doubt the one mobile app that has taken some time to be released. And whilst I do understand that Microsoft’s direction is Mobile and cloud first and that there are a LOT more users using iPhone and Android devices I thought that they would have gotten this out sooner.

But without doubt it is a welcome addition for people who are using Windows 10 Mobile phones. And it looks to have the same great features as what has currently been released on the other platforms.

I am looking forward to see how this improves over time.

You can find out about the details here: Announcing the Power BI app for Windows 10 Mobile

And you can download it from here: Download from the Windows Store

Azure – Preconfigured SQL Server Virtual Machines

It is great to see that in Azure you can now have some help setting up a preconfigured SQL Server Virtual Machine.

In my mind there is almost no one better to aid with this process. I think they are managing the entire Azure SQL Server, Azure Data warehouse platforms so they will have a vast amount of experience as how best to configure the virtual machine. And I have no doubt that by doing this, they too can make customers get better returns.

You can find out about all the details here: Introducing a simplified configuration experience for SQL Server in Azure Virtual Machines

Power BI and Leveraging the Cloud

This is a quick plug on a previous blog post that I did this week.

It is just my personal view in terms of how Power BI is leveraging the Azure Cloud platform and how it all fits together. And it is quite interesting how well they have put it all together and how quick it really is.

You can read the blog post here: Power BI and Leveraging the Cloud (Microsoft Azure)

BI-NSIGHT – Power BI (IOS Power BI App for SSRS, Enterprise Gateway, Printing, AT Internet Content Pack) – SQL Server 2016 (eBook, Mobile Publisher)

The year is finally coming to a close and it has been a really busy but amazing year.

I am looking forward to what will be happening in the Microsoft BI space next year, with the release of SQL Server 2016, as well as I have no doubt that there are a great things planned for Power BI.

Power BI – IOS Power BI App for SSRS

Whilst this is not the most amazing picture that there has been with regards to Power BI, I do think that this is a rather significant thing to mention.

The reason being is that this is the first time that we are starting to see the integration of Power BI and SQL Server (On-Premise) becoming one mobile application. Which is what was in the roadmap that was presented by Microsoft a few months ago.

In my opinion I do see that as next year continues we will see more features integrated. Which I personally think will be really great. What this will mean is that for people on the go, or who want to have a quick view of the data or information, it will always be at their fingertips. They will no longer have to have to log into multiple locations or have multiple mobile applications. They can open one mobile app, and then see the information that they need to see immediately.

I really am looking forward to see how this evolves next year.

If you have an iPhone you can find the updated app here: Microsoft Power BI – iTunes

Power BI – Enterprise Gateway

I am really pleased to see that they have moved so quickly with regards to getting the Enterprise Gateway for Power BI to support both Multi-Dimensional and Tabular models of SSAS. As well as already providing the support for SQL Server direct connectivity. As well as to SAP HANA.

I my opinion I do think that Microsoft is moving in the right direction and starting to provide some functionality for some of their Enterprise customers. And this is one tool that I know will be used to make the administration and access to in premise data sources that much easier.

As well as something that I will be using in the future.

You can find out the details here: Power BI Gateway Enterprise now supports live connections to Analysis Services and SAP HANA

Power BI – Printing

Just a quick note that they now have made it really easy to print your Power BI reports directly from Power BI.

Power BI – AT Internet Content Pack

Here is another great content pack from Microsoft. This time it is related to AT Internet, which help you get insights with your data. And this is yet another valuable content pack that can help its customers and potentially yourself quickly gain the insights to the information you have, to get the best return.

You can find more information here: Explore your AT Internet data in Power BI

SQL Server 2016 – eBook

Microsoft released this eBook, which I personally thought was the perfect timing. With a lot of people being on holidays it did mean that we have the time to read the book.

I downloaded it onto my mobile device, and while I did not read every single page, I did read most of the book. And I thought it was a great read. Not too technical, but it did give a lot of information on the sections that they put into the book. I was particularly interested in the Row Level Security (which I found in my mind has a similar implementation to SSAS), the Stretch Database (which I can foresee being used for large old data sets that are still required to be online, but not accessed frequently) and then Reporting Services.

I did read the entire Reporting Services section, and I enjoyed reading about the printing and how they have finally removed the Active X control. As well as the option to Export to Power Point, which I think a lot of people have been doing manually in the past. As well as other sections which I have read in separate blog posts in the past (Pining SSRS reports to Power BI, New Chart Types)

You can find out the information here: Free eBook: Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview Edition

And you can download it from here: Free eBook – Printable Copy

SQL Server 2016 – Mobile Report Publisher

It was great to see that Microsoft was able to meet their own deadline and have another release of SQL Server 2016 CTP 3.2 which included the new SSRS features.

And as we can see from the picture above they have incorporated the SQL Server Mobile Report Publisher, as well as the application to download and install. Along with this there is also a great blog post by Christopher Finlan which walks you through how to get this up and running.

You can find out all the details here: Mobile Report Publisher preview now available

BI-NSIGHT – SQL Server 2016 (CTP 3.1, SSAS Tabular) – Power BI (Cortana, Mobile App, Enterprise Gateway, Bing Content Pack, API Updates, Sentiment Analysis) – Data Insights Summit – Power Apps

Once again this week there has been a lot of activity in the BI space. Which is great and is definitely keeping me on my toes!

SQL Server 2016 – CTP 3.1 & SSAS Tabular

This week Microsoft released a small update to SQL Server 2016, and one of the features that I am looking forward to testing is upgrading an existing SSAS Tabular project to SQL Server 2016.

I am hoping that there will be some performance improvements, as well as making it easier to use the model now that it is based on JSON.

There were some additional updates that were released as part of the SQL Server 2016 CTP 3.1 which will be in the links below:

You can find out about the Analysis Services Updates here: What’s new for SQL Server 2016 Analysis Services in CTP3.1

And you can find out about what is new in SQL Server 2016 CTP 3.1 here: SQL Server 2016 Community Technology Preview 3.1 is available

Power BI – Cortana Insights

Once again the Microsoft amazing machine has released a whole host of changes since last week.

The first one that I am going to talk about here is the integration with Cortana. I think that this is a good move, as it seems that the world is moving towards using speech to do things, instead of having to type things out.

This is also another great wow factor for showing how powerful Power BI will be. And this means another way to quickly and easily find out insights from your data.

I also have no doubt that this will link up with the Cortana Analytics suite and will make things even easier in the future.

You can read all about it here: Announcing Power BI integration with Cortana and new ways to quickly find insights in your data

Power BI – Mobile App Update

Once again there is another batch of updates to the Power BI App, which is great to see. I know personally from my side that this will be used a great deal going forward.

What I like about this update is that they are focusing on both the iPhone and Android platforms. The one thing that still amazes me that they do not have an app for their Windows Phone which I would think would be good to have.

Along with this having the charts showing a more detail I think is the way to go. The resolution of the phone screens are often higher than what you can get on many monitors. So it can easily and clearly visualize your data and insights.

The other feature that I also like is the welcome page, as often people who are starting to use the app or are wanting to find information often need a starting point from which they can navigate from. I think this is especially the case when there is the potential to have a lot of dashboards. And this would make the experience seamless.

You can find out about the Mobile Updates here: Power BI mobile apps update – November 2015

Power BI – Gateway for Enterprise Deployments

I am very excited to see that as promised or eluded to there now is a Gateway for Enterprise deployments. I can already see in my organization that potentially having to have multiple gateways installed, and then to still configure who has access to what could very quickly spiral out of control.

This is where the Enterprise gateway over time will come into it’s own. I also like the feature that you can see the usage. Which will be very useful, because in my mind if this shows the usage stats as to what cubes or SQL Servers are being used will mean we can see if it is actually being used or not at all. As well as simplifying the deployment of how we manage the connection between the cloud and on premise.

I know that right now it is in Preview as well as only allowing a direct connection to SQL Server, but I have no doubt that over time this will become the required gateway and the Analysis Services Gateway will be replaced by the Enterprise Gateway.

You can find out the details here: Announcing preview of Power BI gateway for enterprise deployments

Power BI – Bing Content Pack

The Bing Content pack is a genius creation from the Power BI Team.

And the reason that I say this, is due to the fact that you can use any search term and it can quickly show you what searches have been happening relating to your search term. As well as showing some related news information.

I have already put it to use within my organization, and it just means another data source which in turn you can then use to quantify your data and what you are working on!

What I also enjoyed about this content pack is it is something you can put into use with immediate effect. It is quick and easy to get it up and running.

You can find out about the Bing Content Pack here: Search Analytics from Bing on your Power BI Dashboards

Power BI – API Updates

There are some great updates for the Power BI API, and whilst I am no developer it does mean that for the development team that I work closely with we can easily and quickly take our Power BI Reports and dashboards and integrate them into our existing applications.

This will mean that we can leverage all the hard work that we have done and have it in an application. Which then means that there is no need for the users to leave their application. As well as having the functionality that Power BI brings to the table.

The new API that was released today was the “Report integration API”

You can find out all about the Power BI APIs here: Power BI for Developers: Reports API and a simple App Registration experience

Power BI – Sentiment Analysis

I came across this blog post by Patrick Leblanc and I thought this was a really amazing blog post.

It really delights me to see how there are really quick and easy ways to integrate other solutions into Power BI, which then enriches your data. And I do think that having sentiment analysis is a great tool to see how people perceive your company or your product.

You can find out how Patrick got this done by viewing his blog: Sentiment Analysis with Power BI

Data Insights Summit

I really wish that I would be able to attend the Data Insights summit.

We are planning on using Power BI as our starting point for our BI journey and I do think that these two days in March would be invaluable not only to find out directly from the Microsoft team what is currently happening, but also what is coming and what is planned for the future.

As well as having the ability to network with fellow people who are also implementing Power BI solutions.

You can find out about it here: Data Insights Summit

Power Apps

Finally, but not lastly I do think that Power Apps is going to drive and change the way we get data from different sources as well as from different content area’s into a digital format.

I can already see how we can leverage this, to make things easier and simple for the users in my organization.

The other thing that I really like is that you can create the app once, but can leverage it on all the different platforms (Web, Mobile, Tablet). And to me this means that the adoption and the use of the app will be that much better used and will ensure it succeeds.

You can read about it here: Introducing Microsoft PowerApps

BI-NSIGHT – Power BI (Desktop Update, Service Updates, API Updates, Mobile App Update, Visual Contest Results, Content Pack – Stripe) – Office 2016 (Excel Updates, Power Query Update, Excel Predictions) – SQL Server Analysis Service 2012 Tabular Update – SQL Server Analysis Services 2016 Extended Events

So this week there was once again a whole host of updates with Power BI, as well as finally the official release of Office 2016.

It sure is a busy time be in Business Intelligence space, especially in the Microsoft space.

So let’s get into it…

Power BI – Desktop Update

So I woke up this morning to see that there has been a massive release in the Power BI Desktop application. I immediately downloaded and installed the update. I have already used some of the features today.

And there was a whole host of updates, too many to go through all of them here, but I would just like to highlight the ones which I think are really great additional features.

I am really enjoying the Report Authoring features, and I have mentioned it before but the drill up and drill down features are really great and allows for more details to be in the report which you will not initially see on face value.

Then under the data modelling section I have to say that I am currently not any DAX guru, but I do appreciate how powerful it is, and how you can really extend your data with so many DAX functions. In particular is the Calculated Table, which Chris Webb has already blogged about and has some great information here: Calculated Tables In Power BI

And there are some great new features with regards to Data Connectivity as well as Data Transformations & Query Editor improvements, which all forms part of Power Query. Which once again enables the author of the reports to enrich the data, which in turn will create great visualizations.

You can find out all about all 44 updates here: 44 New Features in the Power BI Desktop September Update

Power BI – Service Updates

So yet another great update on the Power BI platform.

I think that finally being able to customize the size of the tiles is really good. So that you can fit more meaningful information on your dashboard.

Another great service update is to be able to Share Read Only dashboards with other users. This is great because often you create dashboard and reports, which you want to share with users and let them interact with your data, but not make any changes.

As well as having more sample content packs which will be a great way to showcase how powerful Power BI is.

You can read about it and all other updates here: Power BI Weekly Service Update

Power BI – API Updates

There is no pretty picture for the API updates, but there are some great new features.

The one that I think is really good is the ability to be able to embed a Power BI tile into an application. So at least it gives you the ability to have the great features of Power BI in your application without having to go directly to Power BI.

I also see that there is the ability from what I can see to pass some filters or parameters into the Power BI report via the URL which is really good and can prove to extend the functionality.

These are the details in the API updates

  • Imports API
  • Dashboards API
  • Tiles and Tile API
  • Groups API
  • Integrating Tiles into Applications
  • Filtering Tiles integrated into your Application

You can find out all about it here: Power BI API updates roundup

Power BI – Another Mobile Update

The Microsoft team must be working 24 hours a day with the amounts of updates and additions that are coming out from Microsoft.

They have released some additional updates into the Mobile application which are great, as we all are well aware that having a mobile application really can help showcase your solution. As well as ensure that it gets to the right users and that they can see the related information.

You can find out about the updates to the IOS, Windows and Android details here: Power BI mobile Mid-September updates are here

Power BI – Visual Contest Results – People’s Choice Awards

As you can see above this is the first people’s choice award for the Visual Contest result, which I can see myself using that with my existing data.

You can find out about it and the other entries here: Power BI Best Visual Contest – 1st People’s Choice Award!

Power BI – Content Pack Stripe

Once again this was another great content pack update this week.

There are a whole host of people who are using the Stripe platform payment for their online business. From the really small guys to the big guys. And this gives everyone a really great and easy way to understand and visualize your data. As well as what payments you are getting.

You can find out more about it here: Monitor and Explore your Stripe data in Power BI

Office 2016

I am very happy to see that Office 2016, has been released before the actual year of 2016.

I have mainly been focused on all the features in Excel, due to being in BI. But there are a whole host of updates, fixes and new additions in Office 2016.

You can read all about it and all the details here: The new Office is here

Excel 2016 – Features

With Office 2016 being released this blog post from the Office team shows a lot of the great features that are available in Excel 2016.

It does showcase a lot of great features focused on Business Analysts, as well as how people can leverage all the new features in Excel 2016.

You can read up all about it here: New ways to get the Excel business analytics features you need

Power Query Update

With so many things going on within Power BI, there has been another great release with Power Query.

As you can see with the picture above it is great to finally have the ability to write your own custom MDX or DAX query to get the data which you require from your SSAS source.

Another great feature is the ability to extract a query from one of the steps within your current Power Query query, and then you can use this in another Power Query window. As they say it gives you the ability really easily use the same code over again, without having to do it all over again.

You can read all about it here: Power Query for Excel September 2015 update

Excel Future Prediction

I recently came across a really interesting article from some of the Industry experts within the BI space, and for them to predict how they see Excel’s use as well as where they see it fitting into the BI space in the upcoming years.

There were some really insightful and interesting details, which made me think about how Excel has evolved over the years, and with the current additional investments going into Excel, how this is going to be leveraged and improved in the years to come.

You can read all about their thoughts here: 27 MICROSOFT EXCEL EXPERTS PREDICT THE FUTURE OF EXCEL IN BUSINESS INTELLIGENCE

SQL Server Analysis Service 2012 – Tabular Update

There has been a CU update for SQL Server 2012, and one of the great updates relates to SSAS Tabular for columns that have a high cardinality. Which was a performance issue before this release.

It is great to see that this has been addressed, especially due to the fact that in SSAS Tabular there will be cases when columns will have a high cardinality. And even though it is often super quick, we would like everything to be as fast as possible.

You can read all about the updates to SQL Server CU 8 here: Cumulative update package 8 for SQL Server 2012

SQL Server Analysis Services 2016 – Extended Events

I think that it is great to see that we are finally getting some additional features and updates to Analysis Services.

When I read up about the extended events, this is something really great to see. I actually have been in an exercise to monitor what has been going on our SSAS instance both in terms of performance, as well as which users are accessing the cubes and what they are doing. And currently there is not a super elegant solution to achieve this.

With the extended events this makes it a lot easier and gives you the ability to quickly get the information that you require.

I also love it that you are able to have a live query, which you can use to see if you are specifically running something. As well as if you want to ensure that you are capturing the right events.

This is definitely something that I will be looking to use when we finally can install and use SQL 2016.

You can find out about all the details here: Using Extended Events with SQL Server Analysis Services 2016 CTP 2.3

BI-NSIGHT – Power BI – (Pin to Dashboard, Extending Power BI Pro Trial, Mobile App Update, All About Dashboards, comScore Content Pack) – Cortana Analytics (Azure Data Catalog) – SQL Server 2016 (SQL Server Analysis Services (SSAS) Tabular Parallel Partition Processing) – Office 2016 (Official Release Date 22 Sep 2015) – Project Prajna

Once again there was a lot of updates from Microsoft, as well as some other really interesting information within the BI Space. So let’s get going!

Power BI – Weekly Service Update (Pin to Dashboard, Extending Power BI Pro Trial)

I have to say that they are rolling out service updates almost every week now. Which is great to see and shows the commitment from Microsoft to roll out changes and requirements from users.

In this week’s update it is good to see that there are now some additional options when creating new items to Pin to the dashboard. I do know in the past that I have often found it a little difficult to get the right dashboard item on the correct dashboard.

Also it is good to see that in some cases Microsoft will extend the trial by a further 60 days. As I have experienced in the past, you either do not have the dedicated time to try out a service when you sign up. Or you have not tested out all the features to make an informed decision. And I am pretty sure that after 120 days it will become clear that Power BI is fantastic and a great investment.

You can read all about the Weekly Service Update here: Power BI Weekly Service Update

Power BI – Mobile App Update

It is great to see yet another update with the Mobile App for Power BI. They have made some great additions and improvements. I am looking forward to trying out the collaboration. As I often see that this is a feature that when used can really lead to some great conversations or a great way to promote some great work.

It is also great having the Single Sign On. As even though it does not take a lot of effort. We all enjoy not having to put in our username and password one additional time.

You can read about the additional details, updates and fixes here: What’s new on the Power BI Mobile apps?

Power BI – All About the Dashboards

The Power BI Dashboards provide a great platform for showing valuable information which can very quickly show you information that is important. As well as the dashboards can give you some insights into the underlying data.

And I do think that if you design a great dashboard, you are almost inviting the user to have a look around and interact with your data.

The blog post listed below, explains, shows and gives some great advice on how to build the ideal dashboard depending on what you are trying to display.

You can find out more details here: All About Dashboards

Power BI – Content Pack comScore

This week’s Power BI Content pack is comScore. It is another great content pack for customers and users who use comScore.

I do think that due to it being available on many different platforms there is the potential to provide some great insights into their data.

You can read all about it here: Visualize your comScore Digital Analytix data with Power BI

Cortana Analytics – Azure Data Catalog Overview

Even though Azure Data Catalog is currently available in preview, I do think that this is something that will be integrated into Cortana Analytics.

This is really a great and informative blog post by SQLChick (Melissa Coates) in terms of seeing and understanding how Azure Data Catalog works. This is something that I am interested in, as well as going to look into and see how we can leverage this within my work organization.

I have to say that it looks really good, simple to use, but at the same time making it really powerful at the same time. I also think that once this has been implemented it can really enable an organization to leverage off all their data investments, and allow the users to consume this data. Which in turn can lead to the business gaining more insights, which in turn will lead to better results!

You can find out more information here: Overview of Azure Data Catalog in the Cortana Analytics Suite

SQL Server 2016 – Tabular Model Parallel Partition Processing

Looking ahead to SQL 2016 they are putting in a lot of effort into the different BI components.

This is yet another great update and something that I am sure a lot of people have been asking for and hoping for it to be completed. As well know when we can do things in parallel it means that everything runs that much faster. And who does not like things going faster?

The great thing is that in SQL Server Analysis Services Tabular, there is nothing extra that you have to do in order to run it in parallel. As long as you have created your partitions you are good to go.

You can read all about it here: Parallel partition processing available for Tabular Models in SQL Server 2016 Preview

Office 2016 – Official Release Date 22 September 2015

I have to say that I cannot wait for Office 2016, in particular Excel 2016.

They have done some amazing updates and new additions specifically in Excel. I do know that as soon as I can get my hands on it, I will get it installed and working. And then try and get as many people as I can to also upgrade.

It is great to see that it is being released so soon, and I am sure that a lot of people have provided a lot of feedback and details for Microsoft.

So I am eagerly waiting for 22 September 2015.

You can find out more details here: Microsoft’s Office 2016: The new rules for the rollout, starting September 22

Project Prajna – Big Data Analytics Framework

The final thing to chat about today is Project Prajna.

It is good to see that the Microsoft Research’s Cloud Computing and Storage (CCS) group is working on getting the best out of the big data analytics as well as leveraging the big data storage all within one system.

This in my mind will make it easier and faster to gain really good insights into your big data investments.

It is interesting that they are building a platform where people can accesses it and develop using any .NET programming language. Which I am sure that there are a lot of developers who have experience in .NET, which means that they can leverage their existing experience directly into Project Prajna.

You can read more details about it here: Microsoft forges ahead with ‘Prajna’ big-data analytics framework for cloud services