BI-NSIGHT – Power BI (Data Connector SDK, Analytics Challenge, April Service Content Packs, ArcGIS May Update) – Azure (SSAS Model into Azure

After all the announcements last week here are this week’s updates.

Power BI – Data Connector SDK

I know that this has been something that I have seen asked on the Power BI Community, as well as thought about in terms of having the capability to create your own Custom Data Connector in Power BI.

Don’t get me wrong they have supplied a vast array of connectors already. But by creating the SDK this means that now virtually ANY data, or even potentially anything could be integrated into Power BI. I saw a tweet from Kasper mentioning a data connector for Strava (Which I use a lot for my exercising, as well as having a wealth of data).

You can find all the details here: Data Connector SDK Developer Preview

Power BI – Analytics Challenge

With the Microsoft Data Insights summit coming up they have created an Analytics challenge in three area’s.

Complex Data Preparation, Advanced Analytics and Just for Fun.

It will be really interesting to see what people can do, I am hopeful that I will submit something.

Here are the details: Announcing the Microsoft Data Insights Summit Analytics Challenge

Power BI – April Service Content Packs

There is a new feature from the Power BI Team which as you can see above is to give more details around what are the new Service Content Packs for each month. So as you can see there are quite a few new service content packs for April 2017.

You can read the blog post here if any of the above interest you: Power BI April Service Content Packs

Power BI – ArcGIS May Update

As you can see from above the people from ArcGIS are now updating it on a nearly monthly cadence.

In this month’s updates you now can use Drive Time Area’s, as well as Tooltip fields and a host of bug fixes.

You can find the blog post details here: What’s New in ArcGIS Maps for Power BI (May 2017)

Azure – Getting your SSAS Model into Azure

This is a great blog post by Kasper De Jonge where he shows you how to get your SSAS Tabular model into Azure.

You can find more details here: Getting your on premises SSAS Tabular model to Azure

BI-NSIGHT – Power BI (Desktop Update April – Quick Measures Preview – Mobile Apps Summary – Video Gallery & Ask a Partner Anything – View Related Content Pane – Sneak Peak add new Columns from Example – Tracking Adoption via Power BI Audit Logs)

There has been a whole host of updates and interesting things in Business Intelligence in the past weeks, so please find below the updates.

Power BI – Desktop Update April

This month’s Power BI Desktop update for April has a whole host of great updates and new features this month, which I will highlight what I think is most relevant below.

Report View

The first update in the Report View section is the ability to rename the axis titles. I know that personally this is something that I have been looking for and now the capability is there.

Next is additional updates to the Matrix Preview, in which you can now sort the matrix by the grand total and row headers in ascending or descending order.

As well as now you can also resize the columns as you could do previously in the original matrix.

And finally, you can now word wrap column headers, row headers and values in the matrix preview. This can be configured separately in the formatting pane.

Analytics

Not only has the Power BI team made it better and easier to create the default measures. But with the Quick measures they have made it as simple as a drag and drop and then Power BI Desktop writes the DAX for you. I personally think that is a giant leap forward as it enables users who are not very strong in DAX to still be able to create powerful measures, which in turn will create greater insights into their data. This will also then let people learn how DAX works because they can see and modify the code, as well as give more advanced DAX users the capability to edit the DAX measure if so desired.

This entire preview feature I think is another game changer and it will enable people to quickly create the measures that they require, as well as to get people to build their DAX skills if so required. And I have no doubt that more quick measures will be added.

As you can see above, you can now try Q&A in Spanish. This must be the result of the Power BI Surveys that have been conducted in the past.

Data Connectivity

Once again this is another idea that a lot of people have been asking for and it has already been delivered. This is the ability to connect to a dataset that exists in the Power BI Service.

This is wonderful as what it means is that as long as you have got the required access, you are now able to access a dataset already uploaded into the Power BI Service. So what this also means is that you will not have to worry about creating measures, how the data is updated etc, because you are a consumer of the Power BI dataset.

This also means that now you can have multiple people working on a single dataset. Which is the start of having multiple developers developing reports and insights into your data.

The one caveat is that when you use the Power BI Service dataset you cannot edit or modify anything within this dataset, you will have to get the dataset owner to make the required changes and then for them to upload it the changes or updates into the Power BI Service. But still a giant leap forward.

The Amazon Redshift data connector has now moved out of Preview and is in the Beta phase, so it is easier to find and use.

There has also been updates to the SAP Hana and BW connectors, now giving you the ability to have more control with regards to the parameters selection. I am sure that people that use SAP will find this very welcome.

Query Editing

The ability to add a column by example has been out for almost 2 weeks now, but this is once again (yes I am repeating myself a bit!) a game changer because it now allows people who do not understand Power Query or the M language to quickly and easily build new columns within their dataset. And this also does it in the Query Editor, where I personally think it is the right place for this to be done, so that before it is brought into the Power BI Desktop Model, the data is already there and can achieve better results.

As you can now see above you now can split your column by delimiter or number of rows and if you wanted to split it into Rows.

The basic Group By in the Query Editor now allows you to group by a single column and output by a single column.

The Go to Column is a very handy feature because it allows you to quickly find your column, which is especially helpful when your table is very wide with a lot of columns.

You can find the blog post for the Power BI Desktop Update here: Power BI Desktop April Feature Summary

Power BI – Quick Measures Preview

There is already a blog post out by the Power BI team with regards on how to leverage and use the Quick Measures Preview.

It has some great content and is well worth the read.

You can find the blog details here: Quick Measures Preview

Power BI – Mobile Apps Summary

There have been some additional updates to the Mobile Apps for Power BI which are the Q&A Improvements and 3D touch for iOS.

Multiple SSRS Server support for up to 5 SSRS Servers. As well as improvements to the slicers.

You can find all the blog details here: Power BI Mobile apps feature summary – March 2017

Power BI – Video Gallery & Ask a Partner Anything


As you can see from above the Power BI team has now launched the Video Gallery where you can view tips and tricks on how to do things with Power BI. I think that this is great because it is often easier to see how to do things.

As well as another Ask a Partner anything on 06 April.

You can find all the details here: Announcing the new Power BI Video Gallery and Ask a Partner Anything live event

Power BI – View Related Content Pane

Once again the people in the Power BI team, specifically on the Power BI Service side are making it a lot easier to navigate and understand how your reports piece together.

This is very powerful as well as easy to use, because you get to see all the related content, but you also get the capability to be able to go into the settings or item specific areas, where before you would have had to go through a few clicks to get there.

You can find the blog details here: Announcing the View Related Content Pane: Faster Results with Fewer Clicks

Power BI – Sneak Peak add new Columns from Example

As you can see from above, this is a sneak peak of a new feature that is going to be released in the next version of Power BI Desktop.

I have to say that this is amazing, as it is starting to do the hard yards for you. Yes it might take a bit of practice to get it right, but once you have mastered it, it can save you a lot of time and effort

And the thing that I really like is that it will enable the users who are not so proficient at Power Query to be able to expand on their data, which in turn will lead to amazing insights.

You can read the blog post here: A sneak preview of the new Add Column From Examples data transformation

Power BI – Tracking Adoption via Power BI Audit Logs

This is a great blog post from JAVIER GUILLEN, where he shows you how to use the Power BI Audit logs to show how adoption of not only Power BI, but also the dashboards and reports are being used.

You can find the blog details here: TRACKING ADOPTION VIA POWER BI AUDIT LOGS

SSAS / Power BI – DirectQuery WhitePaper

As you can see above there is a whitepaper for DirectQuery in SQL Server 2016 Analysis Services, it is noted that some of the concepts are shared with Power BI.

And I have already downloaded the whitepaper and will be getting stuck into it very shortly.

You can find the blog post details as well as the link here: DirectQuery in SQL Server 2016 Analysis Services whitepaper

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 (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

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