BI-NSIGHT – Power BI (Upcoming Updates, Forecasting in Power BI, Q&A Updates, Row Level Security, Excel in Power BI, Cortana Integration, New Visuals, Power BI App on Apple Watch, Desktop Trend Lines, Desktop Drill Through, Desktop Conditional Formatting, Power Apps) – SQL 2016 – Part 2
Well with the Microsoft Data Insights Summit I was under no illusion that there was going to be a whole host of updates and great new features to Power BI. And it was great to see that I was not disappointed.
So here are the highlights that I thought would be great to mention for this week’s blog post.
Here is the link to the entire Blog Post from Microsoft, and below are my details from what has been released: Over 5 million subscribers are embracing Power BI for modern business intelligence
Power BI – Forecasting in Power BI
This looks like a really great feature because what it means in my interpretation is that we can now leverage Azure Machine Learning (ML) to help forecast or predict what will happen based on the data we have provided.
I do not know all the details, but I know that this will be very welcome and at least give an indication of where your data is going, either better or worse or the same.
I know that there are some other products that have this capability, but I do think that this can be optimized and over time become a lot more accurate.
Power BI – Q&A Updates
It was great to see that after the initial updates to Q&A, they now not only are providing the capability to improve the service in terms of making it easier to use. They are now giving the ability for Q&A to be run on Direct Query Data Sources.
I was not sure initially how this was going to happen in the past, but in my view I was sure that it would be a feature that would be created or designed.
I do think that having Q&A is not only a great option in terms of selling Power BI, but it also makes it really easy for users to just ask a question and get answers. Which they can then save and have as part of their dashboard. And this will be something I would even use when looking for a quick result. I can just ask the question.
Power BI – Row Level Security for Cloud and Direct Query Sources
This is really a great new feature, and as with my next highlight below what this shows is that Power BI is almost at the point of SQL Server Analysis Services (SSAS) Tabular is cloud ready or SaaS.
I know already that there are a lot of good reasons and processes to use Row Level security, so that we can re-use the one data source for multiple people and only show them the data that they need to see.
There is not a lot to talk about here in terms of how Row Level security works, because it has been around in SSAS Multidimensional for some time, but it is great to see it in the cloud or Power BI.
Power BI – Power BI Data in Excel
This leads on from the previous highlight that it appears now that Power BI is a SaaS, and that once it gets released you can use your Power BI Models in the cloud and interact with them using Excel.
This then means that you can use all the standard Excel functionality. As we all know Excel is the most widely used product from Microsoft. And people are very comfortable using Excel, as well as having great skills in what they do with the data in Excel.
Now this just gives them the capability to do this. As well as it means that you potentially do not have to create a Power BI Model and then an SSAS Tabular Model for Excel. It now can all come from one source.
Power BI – Cortana Integration
It is great to see that they are integrating more of Cortana into Power BI. And in my mind I would think that it is leveraging Cortana to convert the voice text, and then pass this to Q&A which in turn can then provide the required data. I could be totally off the mark, but I would imagine it is something along those lines.
I am sure over time that this will get smarter and more integrated.
Power BI – New Visuals
As you can see above Microsoft have released a whole host of new Power BI Visuals.
I do know that the SandDance visual got a lot of applause, and it does have some great applications that were designed with the required datasets.
I particularly like the Attribute Slicer, because it appears that this one gives you the ability to slice the data, but that it will not take up a lot of screen real estate, as well as giving the option to search for your attribute that you want to slice by.
I did think I read somewhere that now Power BI has more visuals for the users to use than any of the Microsoft’s competitors.
Here are more details of the SandDance visual: Visual Awesomeness Unlocked – SandDance
And you can to here to view all the visuals here: Welcome to Power BI custom visuals
Power BI – App on Apple Watch
Just a quick note to see that they will release an App for the Apple watch. This is great for people who like to have the updates coming onto their smart watches.
Power BI – Desktop Trend Lines
As it would happen they also show cased what is coming up in next release of Power BI Desktop.
And it is great to see that there is the ability to put in a trend line, which can often lead the user to understand the trend of the data that they are looking at.
Power BI – Desktop Drill Through
I personally know that this is something that I have been looking for, as well as very often people have said that Power BI is great but there is no drill through functionality.
Well now it is here and it is awesome. And I know that already when chatting to my fellow peers that they are happy and amazed that it has been done. Which means we can then leverage more of Power BI.
Power BI – Desktop Conditional Formatting
I know that often it helps people to better understand the data when there is some conditional formatting that has been applied.
It is great to see that we now have the ability to do this which will further enrich the Power BI experience.
Power BI – Power Apps
I have no doubt that as time goes on there will be a better or tighter integration with Power BI and Power Apps, as a means of getting data into Power BI which can then be used to further enrich the Power BI experience as well as the related data.
SQL 2016 – Part 2
In part to of the details of SQL Server 2016 they go into the SSAS improvements and new features.
I know quite a bit of this has been released before, but this is one central page where you can see all the improvements, to which there are many as well as additional features.
If you want to see all the improvements and updates you can read about it here: Enable business insights for everyone with SQL Server 2016: Part 2