BI-NSIGHT – Power BI (PowerPivotPro & Microsoft Helping displaced workers, Visualizing weather from Microsoft OMS) – SSAS (Memory Usage (1200 Compatibility Only) report using Power BI) – SQL Server (SP1, SSRS Updates

Another week close to Christmas and another week of great news in the Business Intelligence world.

Power BI – PowerPivotPro & Microsoft helping displaced workers

A quick mention on how it is great to see both the people at Power Pivot Pro & Microsoft are working together to help people find employment.

The great thing about Power BI, is all that you need is a computer and an internet connection and you are good to go.

You can find the details here: PowerPivotPro and Microsoft help displaced workers with near-free Power BI Training Dec 7th

Power BI – Visualizing weather from Microsoft OMS

This is a great blog post where the people from Microsoft explain how using OMS they can leverage the weather data that they collect and publish it to Power BI.

If you currently use Microsoft OMS this could be a great resource.

You can read up about it here: Visualizing weather information in Power BI with data from Microsoft OMS

SSAS (SQL Server Analysis Services) – New SSAS Memory (1200 Compatibility Only) report using Power BI

Here is another really great resource of information from Kasper De Jonge, where he has updated his SSAS Memory usage report, with the latest versions of SSAS, but also to use Power BI to visualize your memory usage.

Also Kasper has put it on GitHub which means that it is open for anyone to use, as well as to contribute and hopefully make it into an amazing Memory usage report.

You can find the details, as well as how to download the file here: New SSAS memory usage report using Power BI

SQL Server – Service Pack 1

It is not often that there I would blog about a service pack, but this is an exception. As you can see above Microsoft have made available a whole host of features that were previously only for the Enterprise Edition which is now available in not only Standard Edition but also Web, Express & LocalDB.

One thing to note is that it would appear that all of the licensing updates are in the RDBMs space.

There are 3 updates for SSAS whichi is firstly that SSAS is NUMA Aware, I know that this is something people have been asking for, for a long time. As well as Memory Allocation and Heap Fragmentation.

You can find the blog post here, which has all the detailed information, as well as what additional update there are in SP1: SQL Server 2016 Service Pack 1 (SP1) released !!!

SQL Server – SSRS (SQL Server Reporting Services) updates with SP1

Not only where there the licensing features with SQL Server 2016 SP1, but also updates to SSRS, as you can see above the SSRS team is listening to what clients and customers are asking for and have updated the Details view.

They have also updated the Execution logs, so that you can now get some basic information in terms of who is accessing and viewing mobile reports.

And finally direct navigation options for KPI’s, which makes it easier to navigate to a direct link when viewing a KPI.

You can find all the details here: What’s new in SQL Server 2016 SP1 for Reporting Services

BI-NSIGHT – Power BI (Mobile Apps Update, Microsoft Teams, Extending Project Online Content Pack, Featured Data Stories, Streaming Data Set Example from Chris Webb, Dashboard Makeover Webinar) – Azure (Analysis Services)

Another week has gone by, and some more updates in the world of Business Intelligence

Power BI – Mobile Apps Update

There are quite a few updates for the Mobile BI apps, and it is good to see that it is across all platforms.

The easier navigation is always welcome because with a phone it is always tricky to navigate and see what you want to see. It also makes perfect sense that when you open your Mobile app, you want to see your favourites dashboard, because that is what you want to see first.

With regards to notifications, these are great updates, not only is the notification more descriptive, but also easier to dismiss once you have seen the notification.

As well as being able to view your report by location (on windows phone) and the ability to try the SandDance visual on the surface hub.

You can find the mobile apps blog update here: Power BI Mobile Apps feature summary – October 2016

Power BI – Microsoft Teams

Last week or this week Microsoft announced a new platform to enable productivity and collaboration called Microsoft Teams. You can find the details with regards to Microsoft Teams here: Microsoft Teams – Group Chat

And now this week they have now enabled this for Microsoft Power BI. This will further add to the Power BI story in terms of collaboration and I think it will make it even easier for people to communicate effectively and quickly.

You can find more details here: Power BI teams up with Microsoft Teams

Power BI – Extending the Project Online Content Pack

The Office team has been busy creating and extending the Project Online Content Pack. This blog post not only shows you where to get the data, but it also explains how to utilise the data and tips and tricks to get the most out of your data.

If you use Project Online read their blog post here: Extending the PowerBI content pack for Project Online

Power BI – Featured Data Stories

Once again this month from the Power BI Community is the featured data stories.

I always go and have a look, as there are some really good data stories told.

You can find the details here: Congratulations to this month’s Featured Data Stories Gallery submissions

Power BI – Streaming Data Set Example from Chris Webb

This is a really great and insightful post from Chris Webb. Not only does he show and explain how to get the streaming data sets working, but has an example that you can try out with yourself. (I personally did try it and it works!)

For me there are two things to take away from this. The first is that it is really quite easy and simple to create a streaming data set. Second is that I am already thinking of how to leverage this for other scenario’s.

You can find Chris’s Blog post here: Pushing Data From Excel To Power BI Using Streaming Datasets

Power BI – Dashboard Makeover Webinar & Submit your data

There is a Webinar on 17 November 2016, where you can see how they do a dashboard makeover.

Not only that but there also is the option for you to submit your entry for it to be made over.

You can find the details here: Submit your work and attend our next Dashboard Makeover

Azure – Analysis Services

In the link below is a great blog post by Kasper De Jonge and he goes into some great high level details as to why you would want to use Analysis Services in Azure. It is a really great article and does give some food for thought.

An example would be never having to upgrade to another version of Analysis Services, as well as having it being Highly Available, which in the past takes a significant amount of effort.

You can find all the details here: Analysis Services in Azure, when and why…

BI-NSIGHT – Power BI (August Power BI Desktop Update, Future Download Report & Snap to Grid, IntelliSense coming to Power Query, Power BI Training, WebTuna Content Pack, Building a Real-Time IoT Dashboard, Chris Webb Loading Data from Multiple Excel Workbooks saved in OneDrive, SCCM Solution Template) – SQL Server (SSAS Integrated Workspace Mode, SSMS Update, Report Builder Update)

Last week there was not a lot on the go, but it seems to have picked up this week, so here are the latest insights.

Power BI – August Power BI Desktop Update

As I am sure some of you would have already seen and heard and I personally have to echo what other people have said, it is great to see how the Power BI team, as well as Microsoft take on board the issues and problems that their users face, and in this instance how quickly they have made the change, so that we can get not only the new functionality. But as requested also have the ability to use the older functionality also.

What I am referring to here is the Drill experience.

So you can use the double down arrow which will do the previous experience which will show the next level of the hierarchy.

And the new experience which is the split arrow which will perform the new inline hierarchy experience.

You can find the details here: August Power BI Desktop Update: Updated Drill experience

Power BI – Future state (Download Report) & Snap to Grid

As you can see with the image below on certain versions of the Power BI Service they have started provisioning the ability to download your Power BI report as a PBIX file. Which will be a great addition.

Next you can see that they have started working on the Snap to Grid functionality which is another great addition which will be available sometime in the near future.

Power BI – IntelliSense coming to Power Query

Just a quick update that IntelliSense is coming to Power Query, I have been working in the nuts and bolts of Power Query and this will be a very welcome addition.

Power BI – Training


There are some great free training available to get into Power BI, as you can see above there is a “Dashboard in an Hour” as well as “Dashboard in a Day”. Not only that but there is also a really great and valuable edX course (which I have already completed) which offers some great content and learning experiences.

You can find the details about the different options here: Power BI Dashboard in a Day and Dashboard in an Hour training near you

Power BI – WebTuna Content Pack

Here is another content pack, this time from WebTuna, which is an on-demand service for alerting and monitoring the performance of your internet or internet sits. And I am sure due to the nature of the business model as well as analytics in terms of usage and where it is coming from this will give some great insights into their customers data.

You can find all the details here: Explore your WebTuna Data with Power BI

Power BI – Building a Real-Time IoT Dashboard

In this blog post from the Microsoft Power BI team they show you how to setup, configure and create a real-time IoT dashboard.

Whilst the concept is very basic (which I think is a good thing to start learning) it also shows how powerful this can actually be.

You can find the details here: Building a Real-time IoT Dashboard with Power BI: A Step-by-Step Tutorial

Power BI – Tracking Changes in PBIX files

This is a blog post from Helen Gore, where they have created something that appears to be very simple, but actually is very powerful.

What she explains in her blog post is how they track changes in their Power BI Desktop (PBIX) files, so that when other people are working on the same file, they know what the previous changes were.

You can find all the details here: HOW TO TRACK CHANGES IN POWER BI DESKTOP

Power BI – Chris Webb – Loading Data from Multiple Excel Workbooks saved in OneDrive

This is an excellent blog post from Chris Webb where he shows how to not only load multiple Excel Workbooks, but ones that are saved on OneDrive Personal or OneDrive for Business, as well as ensuring that they get refreshed on your schedule.

I will not go into all the details, as you can read them on his blog post here: Loading Data From Multiple Excel Workbooks Into Power BI–And Making Sure Data Refresh Works After Publishing

Power BI – SCCM (System Center Configuration Manager) Solution Template

If my memory serves me correctly this is the second Power BI Solution Template from the Microsoft Power BI team.

And this time it is for SCCM, and having worked with this data in the past, it is really great to see how easily it can be used to show insights into your SCCM data. As well as it does appear that you can integrate 3rd party information in SCCM also.

You can find the details here: Announcing the Power BI solution template for System Center Configuration Manager

SQL Server – SSAS (SQL Server Analysis Services) Integrated Workspace Mode

This is a great update for SSDT and the modelling experience when working with SSAS Tabular models. You now can use an integrated workspace, which means you do not have to connect to an SSAS Tabular Server.

The thing to note is that you might need additional memory, as well as they highlight in the blog post drivers for both 32bit and 64bit depending on the version of SSDT.

You can find the details here: Introducing Integrated Workspace Mode for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

SQL Server – SSMS (SQL Server Management Studio) Update

Here is the monthly update for SSMS, and there are quite a few updates in this release.

You can find all the details here: Download SQL Server Management Studio (SSMS)

SQL Server – Report Builder Update

It appears that for SQL Server 2016 the report builder will be following a similar release process as SSMS and SSDT where there will be more frequent updates to report builder.

I am sure that this will enable a lot of future updates and enhancements for report builder.

You can find the details here: SQL Server 2016 Report Builder update now available

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