Refreshing data in Power BI from SQL Server Read-only or Secondary Replica’s

I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector.

NOTE: This could potentially be used for a whole host of other OLE DB providers

NOTE II: This only applies to Imported datasets at the time of writing this.

In my example i am going to be using the OLE DB Connector for SQL Server Native Client 11.0

I will explain below how to create the connection, as well as how to configure it in the Power BI On-Premise Data Gateway.

Connecting to the Data in Power BI using the OLE DB Connector

  • The first thing I do, is to connect to the data, by clicking on Get Data and then finding my OLE DB Connector
    • I then click on Connect
  • The great thing about Power BI, is that after I click on Connect, there is a button to Build the connection string, so I click on Build
  • This brings up the Data Link Properties Window
    • I click on SQL Server Native Client 11.0
    • I click on Next
  • I then put in my Server Name, select Use Windows NT Integrated Security and select my database
    • NOTE: Depending on how your Gateway authenticates to SQL Server will depend on what you put in here.
    • NOTE: I always put in the FQDN name for the SQL Server instance.
    • I then click on Test Connector to make sure that I can connect.
  • I then click on All, where it says Application Intent, it will default to READWRITE
    • NOTE: This is the IMPORTANT part where I want to make sure that it will use the Read-Only replica or secondary replica
    • I clicked on Application Intent and then clicked on Edit Value
    • I then clicked on Ok to complete the changes
  • And then I clicked on Ok again.
  • I can now see my connection string built for me
    • NOTE: If I scroll across I can see and confirm that I have set the Application Intent to ReadOnly
    • NOTE: Make a copy of the connection string above. This will be used when creating the data source in the On-Premise Data Gateway.
  • There is an option under Advanced Options, if you want to put in a SQL Statement, that is totally up to you, or you can click Ok.
  • I was then prompted for the OLE DB Provider credentials.
    • As far as I understand this is so that the credentials are stored separately from the connection string and not stored in clear text.
    • I selected Windows and then “Use my current credentials”
    • I then clicked Connect.
  • I was then prompted with the Navigator which allowed me to select the table that I wanted
    • I then selected the table that I wanted and clicked Edit
    • NOTE: I always prefer to Edit the queries in the Power Query Editor before loading them into the data model.
  • I then added it to my data model
  • And uploaded it to the Power BI Service.

Creating the Data Source in the Gateway in the Power BI Service

NOTE: You will have to ensure that you have got the permissions to add data sources to the Gateway in the Power BI Service.

  • I went into the Power BI Service and clicked on Manage Gateways.
  • I found my associated Gateway, then clicked on the Ellipses and selected Add Data Source
  • I then configured it with following:
    • Data Source Name
    • Data Source Type
    • Connection String (NOTE: You can get this from your PBIX file if you did not copy it from the earlier step
    • Authentication Method, I chose Windows. Yours possibly will be what you connected to in Power BI Desktop.
    • I then put in the username and password
    • Finally, under Advanced settings I selected Privacy Level to None
    • I then clicked Add
  • I then got the confirmation that it was successfully created
  • I then went into my App Workspace where I had uploaded my PBIX, then into the settings and configured it to use the Gateway.
    • I then clicked Apply.
  • I tested the refresh and it successfully refreshed
  • My final test was to sit with the DBA and ensure that when my data was being refreshed that it was reading from the read-only/secondary replica which it was.
    • I always suggest double checking to make sure that it is working as expected, and to not assume that it is working.


In this blog post I have showed how you can now connect and import data from a read-only or secondary SQL Server replica. This has really been great for some of my customers who want to ensure that the data refresh queries will not impact the data warehouses or production systems.

Please feel free to leave any comments or suggestions, I do enjoy getting them.

Additional Note

I needed to ensure that I had the latest versions of the OLE DB Providers installed for this to work as expected.

I would suggest making sure if you are going to use the native OLE DB provider that you install the latest version from here: Microsoft OLE DB Driver for SQL Server

Power BI RoundUp – Webinar on Advanced Data Prep – Data Flows in Power BI – On-Premise Data Gateway Update – New Power BI Regions in Azure – General Availability of Custom & Certified Data Connectors

Here is my weekly Power BI related round up, I hope that you find this information relevant and keeps you up to date with everything that is happening with regards to Power BI.

Power BI – Webinar on Advanced Data Prep with Dataflows 

There is an upcoming Webinar on 13 November 2018, where Anton Fritz will introduce you to what Power BI Data Flows are and how they can be used.

The Webinar details can be found here: With Power BI dataflows for unified data and powerful insights

Blog – Dataflows in Power BI

If you are interested in Power BI Dataflows, Matthew Roche from the Power BI team has a series of 6 blog posts where he goes into a lot more details on data flows, what they are and how they can be used.

I have read all of them and I would recommend reading through them if you are interested in how you can leverage Power BI dataflows going forward.

As well as hit the ground running.

Blog post details here: Dataflows in Power BI

Power BI – On-Premise Data Gateway Update for Nov

There is an update for the On-Premise Data Gateway for November, where they have updated the Gateway with the following:

  • Enhancements to the Vertica and OData connectors
  • Public preview for the SAP HANA & BW Single Sign On (Kerberos) Support
  • Improved Diagnostics
  • October 2018 Mashup Engine

You can find all the details here: On-premises data gateway October update is now available

Power BI – New Power BI Regions

It was announced this week that you can now get Power BI in 3 new Azure Regions which are:

  • Central India
  • Australia East
  • Central US (Iowa)

You can find more details here: New Power BI regions in India, Australia, and the United States

Power BI – General Availability of Custom & Certified Data Connectors

Custom & Certified data connectors are now generally available in the Power BI Service.

This will now allow you to not only connect to any data source but also have the functionality to be able to refresh the data via the On-Premise Data Gateway

You can find more details here: Announcing General Availability of Custom and Certified Connectors for Power BI

Power BI Gateway – How to remove a Gateway Instance from the Gateway Cluster

I recently was troubleshooting a performance issue for a customer where their LiveConnection was slow when connecting to an On-Premise SSAS Tabular server via the On-Premise Data Gateway.

One of the things that I had to do was to remove an existing On-Premise Data Gateway from a cluster, so that I can then move the Gateway onto another server.

NOTE: Even if you uninstall the On-Premise Data Gateway from a server it will still exist in the Cluster Configuration, so I had to ensure that I had it completely removed.

Whilst I was going through the steps I found that it was a bit of a challenge to complete the steps, so this inspired me to complete this blog post below. I do hope that in the future this could be part of the On-Premise Data Gateway.

I completed all the steps below using PowerShell, and whilst PowerShell might appear to be difficult, if you follow the steps below it should be straight forward (Hopefully my blog instructions are easy enough to follow!)

Running PowerShell Scripts

The first thing that I did was to run the PowerShell scripts where I have already installed the On-Premise Data Gateway. This is because the PowerShell scripts are part of the installation.

I opened PowerShell ISE and run it as Administrator

Importing the module

In PowerShell I then use the code below to navigate to the Data Gateway’s Folder

cd 'C:\Program Files\On-premises data gateway'

I then imported the module as shown below.

Import-Module .\OnPremisesDataGatewayHAMgmt.psm1

Logging into the Power BI Service

The next step I had to complete is to log into the Power BI Service, because this then enabled me to get the details which are part of my tenant.

Login-OnPremisesDataGateway -EmailAddress

Getting all the Gateway Clusters

Next, I wanted to get a list of all the Gateway Clusters which are within my tenant.

NOTE: In a large organization there might be a lot of Gateway Clusters, so it might be better to export the data into a file if this is the case.

I then ran the following PowerShell script below to show me all the Gateway Clusters.


And this was the output

Getting the Member Gateways inside a Specific Cluster

What I now recommend doing is to first find all the members of a specific Gateway cluster.

This ensures that not only do I have the current Gateway Cluster ID, but also ensures that I am only getting the members of the gateway where I want to remove a member.

As with my example above I put in the following into PowerShell

Get-OnPremisesDataClusterGateways -ClusterObjectId 9c9697b7-XXXX-XXXX-XXXX-b481de215945

The output was a list of the members that were part of my gateway as shown below.

I could then see above that I had 2 members in my Gateway Cluster.

The one thing that I did note is that the Primary Instance in the Gateway Cluster has the isAchorGateway = True

I wanted to remove the second member in the Gateway, so I made a note of the gatewayObjectId

Removing Member from Gateway Cluster

I then ran the following code in PowerShell below to remove the member from the Gateway Cluster

Remove-OnPremisesDataGateway -ClusterObjectId 9c9697b7-XXXX-XXXX-XXXX-b481de215945 -GatewayObjectID 3ed46c5d-XXXX-XXXX-XXXX-eb13b6c676d

Once the above was completed it came back to the PowerShell prompt.

Confirmation that I had removed the member from the Gateway Cluster

The final step I did was to confirm that I had removed the member from the Gateway Cluster.

I re-ran the PowerShell script which shows the members of the Gateway Cluster

Get-OnPremisesDataClusterGateways -ClusterObjectId 9c9697b7-XXXX-XXXX-XXXX-b481de215945

And now I got the output where only the Primary member in the instance remained


In the steps above I have shown how to remove a member from an instance of an On-Premise Data Gateway Cluster.

What I did then do with my customer was to move the Gateway Cluster over to a new dedicated Virtual machine, and I did this by installing the On-Premise Data Gateway software on a new server, and then migrated the On-Premise Data Gateway to the new dedicated virtual machine.

I always enjoy getting comments and suggestions from my blog posts, so please feel free to comment to suggest something.

BI-RoundUp – Power BI (Service & Mobile Update for July & August 2018 – User Research Panel – On-Premise Gateway Update for Sep – Webinar on Power BI Dashboard Comments)

Here is this weekly BI-RoundUp where I will detail what updates there have been in the past week.

Power BI – Service & Mobile Update for July & August 2018

In the past two months there has been a lot of updates to the Power BI Service and the Power BI Mobile App. All the details are below with links as per the blog post.

I am not going to go into any detail, due to it already been covered before, or it is the relevant links below.

BI-RoundUp – Power BI (On-Premise Data Gateway August)

This week has been rather quiet, but I have a feeling that if Power BI Desktop gets released next week, we will be back at it and have a whole host of updates.

Power BI – On-premise Data Gateway Update for August

In this month’s update there is additional improvements for Custom Data connectors.

And it also has got the August version of the Mashup Engine.

You can find all the details and content here: On-premises data gateway August update is now available

That is it for this week, short and sweet!

BI-RoundUp – Power BI (July Desktop Update – Admin APIs & PowerShell for Power BI – Multi Geo Support for Power BI Premium – Power BI & SharePoint – On-Premise Gateway Update for July – Developer Update for July)

Since the Business Applications Summit there has been a whole host of updates to Power BI, so please find all the details below.

NOTE: This is once again a longer read with just so many updates that have come through. And it is well worth the read.

Power BI – July Desktop Update

As with every month I will highlight the features from the monthly update


As shown in the picture above Composite models are now available in Power BI Desktop

What are Composite models? This is where you can combine DirectQuery (All other sources except for SSAS) with data that you have imported into your model (for example an Excel spreadsheet)

This allows you to combine data from DirectQuery with Imported data and it will all work well together. This is really an incredible feature and will allow for a whole host of new data scenario’s.

Along with this there is also now the capability to be able to do a Many:Many relationship, which will apply to all relationships in your composite model.


There has been a big improvement to the Visual headers as shown above, now where the visual headers are within the visual. This is compared to the previous iteration where there was a big block above the visual. Not only this, but you can also control which visual aspects you want to be made available.

As shown above there is now the capability to create a Wall Paper which will format the grey area outside your report as shown above.

There has also been a theming update all the visual properties can be formatted through theming.

Shown above, there are now tooltips for Table and Matrix visuals. Not only that but now you can also toggle the switch to have Tooltips per visual in your report. By default they are set to be on.

The Slicer has got some updates for people who require accessibility, can now access the slicer and interact with it via the keyboard and screen reader

The formatting pane has had a revamp and as you can see above, it has had some subtle changes in terms of colouring to make parts easier to get to. As well as better spacing and new toggles to make the formatting experience that much better and easier to use.

There is now stepped line support in line and combo charts. As well as there are additional formatting options that can be used.

People have asked for the ability to be able to toggle data labels for individual series, and this has now been released for combo charts.

Previously when trying to sort items in a visual it was a bit of a challenge to get it done. But with the new updates as shown above, not only are the Sort Desc and Sort Asc separated, but now you can also pick which field you want to sort by.

There is now the ability to find insights through distributions of your data. Not only that but you can select different slicers as shown above with Mod, Low and High. To better understand the distribution of your data.

Custom Visuals

There now are Certified Custom Visuals from the Market place which have to meet code requirements and additional code check by the Power BI Team. You can see from the image above that they have got the blue tick.

There is now additional Organisational Custom Visual settings where the Admin can disable a Custom Visual and the next time the report is viewed, the visual will display as shown above to the end user. Another great Admin capability.

There are a whole host of new Custom Visuals shown below.

Visio Custom Visual

Mapbox Generally Available

Datatext Box

China Scatter Map

Data Connectivity

Direct Query support for IBM DB2 in preview.

There have been improvements to the Web Connector with support for importing multiple custom tables. And the ability to auto complete when specifying values. And the exposure of the Html.Table function in the Query Editor

And finally, the SAP HANA has now got default variables when input controls.

You can find all the blog post details here: Power BI Desktop July 2018 Feature Summary

Power BI – Admin APIs and PowerShell scripts

Whilst this might not look like the greatest screenshot above, what you now can do is access all Power BI Assets in a tenant. This is really awesome news and something that I have been waiting for quite some time.

As in the blog post it explains how you need to get it configured and then run the PowerShell scripts to get the data you require.

All the blog post details can be found here: Announcing APIs and PowerShell Cmdlets for Power BI Administrators

Power BI – Multi Geo for Power BI Premium

There is a preview release for Power BI Premium when creating it where you can specify where the data will reside. As shown above when selecting the capacity and assigning it to a workspace you can then assign it to a workspace in a specific region.

More details can be found here: Public Preview of Multi-Geo for Power BI Premium

Power BI – SharePoint and the road ahead

The Power BI Team has been looking to improve the integration between Power BI, Power BI Report Server and SharePoint.

Starting with SharePoint 2019 and SharePoint Online the following will be coming:

  • Adding support for all major report types across all platforms. This includes SSRS Reports, Power BI Reports and Excel Workbooks.
  • Recently announced easier ways to leverage CSV and Excel files from SharePoint directly into Power BI.

For Power BI Report Server the following will be coming:

  • Power Pivot Scheduled Refresh for Excel Workbooks.
  • Adding modern authentication support with ADFS (Active Directory Federation Services) / AAD (Azure Active Directory)

You can find the details here: Power BI and SharePoint – the road ahead

Power BI – On-Premise Data Gateway Update for July

The update for the On-Premise Data Gateway for July includes the following:

  • Public preview for the Custom Data Connectors in the Enterprise Gateway.
  • Request distribution of data queries across all gateways in a cluster.
  • Support for Single Sign On (SSO) for Spark in the Power BI Service.
  • Diagnostic check to see if the On-Premise Data Gateway can access all the ports required to work successfully.
  • It now includes the July version of the Mashup Engine.

All the details and more can be found here: On-premises data gateway July update is now available

Power BI – Developer Update for July

Below are the Developer updates for July:

  • Ability to programmatically control the visual headers for specific visuals, which is now also available in Power BI Desktop.
  • New Developer Center under the learning in the Power BI website which is a one stop location for users looking to develop solutions using Power BI
  • Power BI Embedded is now available in the China Cloud.
  • There have been some updates to the Custom Visuals to allow High Contrast mode Support for accessibility options.
  • Source code available for the following Microsoft Custom Visuals.
    • Heat Stream
    • Card Browser
    • Text Filter
    • Timeline StoryTeller

The details for this blog post can be found here: Power BI Developer community July update

BI-RoundUp – Power BI (Developer Update for June – On-Premise Data Gateway Update for June – Securing your connection between Power BI & Azure SQL Database)

I must admit that I have been a little quiet with regards to my BI-RoundUp and it is partially due to being extremely busy working. As well as preparing for SQL Saturday Sydney and my presentation at the Business Applications Summit in Seattle at the end of July.

As they always say, the show must go on, so here is my latest BI-RoundUp

Power BI – Developer Update for June

If you are using Power BI Embedded or the developer features of Power BI, there have been some recent updates.

Embed Capabilities

You can now set the slicer values through the Javascript API. This means that when the report loads it can have the slicers pre-set.

As shown in the image above, you now can use themes in embedded dashboards.

In the playground tool (which I suggest everyone go and have a look at), it is now a lot more interactive in terms of it now being able to show “Dynamic Report Layout” and “Capture and share Bookmarks”

Automation & life-cycle management

The documentation for the Power BI REST APIs has been updated in terms of their documentation which is auto generated from Swagger files. I had a look and I do like the look of how it all works.

Power BI Embedded in Azure

There is a note that Power BI Workspace collections are going to be depreciated will no longer be available.

And finally, the Custom Visuals support report themes.

All the details from the blog post can be found here: Power BI Developer community June update

Power BI – On-Premise Data Gateway Update for June

There is an update for the On-Premise Data Gateway, which includes a lot of bug fixes and improvements.

It also includes the June version of the Mashup Engine that is currently found in Power BI Desktop.

Here is a link to the blog post: On-premises data gateway June update is now available

Power BI – Data Gateway Update for June – Securing your connection between Power BI & Azure SQL Database

If you are currently getting data from Azure SQL Database, there is an option to “Allow access to Azure Services” which allows any Azure Service to be able to contact your Azure SQL Database.

In some scenario’s this is not secure enough.

In the link below it explains how to secure the connection between Power BI and your Azure SQL Database so that it can only be accessed by the On-Premise Data Gateway.

There is quite a lot to go through, which is detailed in the blog post: Securing the connection between Power BI and Azure SQL Database

BI-RoundUp – Power BI (Help Improve Power BI – Gateway Update for May)

Fortunately, there has not been a lot of activity in the Power BI space, which gives me a chance to catch up on some reading (Beginning DAX with Power BI  by Phil Seamark) and to have a bit of a rest.

Here are the updates for this week.

Help Improve Power BI

The Power BI Team has a survey out, in which they ask some questions to better understand how people use Power BI. There are also some sections where you can put in your own comments and help improve Power BI.

You can find the blog post here: Help Improve Power BI

Gateway Update for May

The monthly update for the On-Premise Data Gateway is here. And in this month’s update there are updates to Single Sign On (SSO) for Impala and SAP Hana.

As well as the Mashup Engine has been updated to match the May version of Power BI Desktop

All the details are here: On-premises data gateway May update is now available

BI-RoundUp – Power BI (On-Premise Gateway Update – Developer Community Update)

Here is this week’s BI-RoundUp. I am hopeful that by this time next week the latest version of Power BI Desktop will be released!

Power BI – On-Premise Gateway Update

By far the biggest news is the capability to use Custom Data Connectors in the Personal Versions of the On-Premise Data Gateway. The Power BI Team did indicate in the blog post that support in the Enterprise version will be coming in a few months. This is fantastic to see it being made available.

There now is single sign on support using Kerberos for SAP Business Warehouse Server

And finally, there is the updated version of the Mashup Engine to the April version of Power BI Desktop

Here is a link to the blog post: On-premises data gateway April update is now available

Power BI – Developer Community Update

As you can see above for the Developer community update there now is the capability to leverage Custom Report Tooltips and the Q&A explorer.

There is now also new Azure Resource Metrics which allows for better metrics to understand how your Power BI Embedded application is working with the following metrics.

  • It will show Memory usage being used
  • It will show when there is Memory Thrashing, which is defined as when a report is trying to be run, and it needs to evict another dataset in order for your dataset to be loaded into memory. And this only applies to imported datasets.
  • It will show QPU High Utilization which shows the Query Processing units every minute on your resources when it is about 80%

There is now the capability to set up alerts on your Azure resource.

Finally, there is a new learning channel to create custom visuals with a hands-on lab.

All the details of the blog post are here: Power BI Developer community April update

BI RoundUp – Power BI (March Desktop Update, Share Content with anyone via email, Persistent Filters, Mixed Reality App, Service & Mobile Summary for Feb, Data & BI Summit)

After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door.

Which means there is quite a lot to cover in this week’s BI-RoundUp.

Power BI – March Desktop Update

Once again, I must repeat what I have said before, the Power BI team has once again released some amazing new features. Which I think is continuing to make Power BI such a compelling and amazing product to not only use, but to show potential customers.

As I do with every month’s update, I will highlight the features which I feel are worth mentioning.


Without a doubt the Report Tooltips is a game changer. Not only does it give an almost drill through type of feature, but it is context aware. So, when you enable the tooltip it will take into account all the filters that are being applied and apply that to the tooltip. This allows users to gain more insights without having to navigate to another page.

Bookmarking is now generally available, which means that it is now fully supported. As well as you will no longer need to go into the Preview Features in Power BI desktop to enable the feature.

Additional formatting improvements for this month is for the table and matrix, where you can now modify the display units to show it in a more meaningful way. As well as you can set the precision in terms of decimal points. One thing to note is that it will override the settings that were defined in your model.

You can now turn off the Visual headers for the entire report. This is particularly useful when you want to embed the reports. This will remove the Context Menu’s, the Focus Mode, drill down, and the option to pin the visuals. This could potentially also make the pages a read only style report.

When you are now adding in new visuals into your Power BI report, it will now look at the existing visuals and place it where it thinks it should logically go. This is great if there are already a few visuals where it can save you some time placing the visual where you wanted it to go.

Custom Visuals

There are a whole host of new Custom Visuals which are detailed below.

Mapbox visuals which have a lot of amazing options for viewing maps

User List by CloudScope

Timeline by CloudScope – Similar to a Twitter like feel

KPI Chart by Akvelon

R DataTable

Outliers Detection

Data Insights by MAQ Software

Dumbbell Chart by MAQ Software

Clustering using OPTICS by MAQ Software

Data Connectivity

There have been improvements to the SAP HANA connector.

Both the SAP BW Direct Query and Azure Analysis Services are now generally available.


The error reporting has now been integrated with Windows Error reporting. What this means is that it now will contain more information. You can also view all your previous errors. As well as if you do not have the time to send the error report right away you can send it later.

You can find all the detailed information in the blog post: Power BI Desktop March Feature Summary

Power BI – Share Content with anyone via email

You can now Share your Dashboards, Reports or Apps with any email address including (, and Gmail. This is really great when you have users or organizations that use the public hosted email addresses.

One word of caution, is to ensure that only the people who are required to send emails externally have the requirements. And other people that do not require it, have it disabled.

You can find all the details on how to share here: Share your Power BI content with anyone by email

Power BI – Persistent Filters

One of the time-consuming tasks in the past was, when you went back to a report, if there were multiple slicers and filters, you would have to reset them each and every time you went back to the report.

This is now a thing of the past with persistent filters.

Persistent filters will now remember your Filters, Slicers, Drill downs and sort order for your reports. So, when you go back to the report it will remember them.

This is a great feature and will make the reporting and analytics experience that much more enjoyable and quick to gain the insights you require.

All the details are here: Announcing Persistent Filters in the Power BI Service

Power BI – Mixed Reality App

With the use of the HaloLens and the Mixed Reality App there now is the capability to be able to Pin Power BI reports to physical locations or to have it tagged within the App.

What this means is that if there is a user on the factory floor, they can have a Power BI report pinned into the machine, so without having to look at their phone or open a laptop they can gain insights as they are moving around.

I think that this opens a whole new avenue and the things that you can imagine are almost endless.

The blog post details are here: Power BI for Mixed Reality app now available in Preview

Power BI – Service & Mobile Summary for Feb

Whilst some of the new features have been covered before here is a quick overview.

There is now the facility to automatically install apps.

A new feature that I was not aware of is now additional
Power BI Premium Capacities for P4 and P5, currently only available in West US and Southeast Australia.

Organizational Custom Visuals can now be controlled by the Power BI Admin

The February update to the On-Premise Data Gateway which has the latest Mashup Engine, and can also refresh data sources from both On-Premise and Cloud.

And finally, updates to the mobile app where you can now share from the Mobile App, you can drag your finger across your screen to get the tooltips and improved hyperlinks

All the details are here: Power BI Service and Mobile February Feature Summary

Data & BI Summit in Ireland

The Data & BI Summit in Ireland will be happening from 24 – 26 April 2018.

They have recently announced the keynote speaker John Doyle, Senior Director of Product Marketing on the Cloud & Enterprise team at Microsoft.

This looks to be a great conference and would be well worth attending if you are able to.

All the Summit details are in this blog post: Data & BI Summit announces keynote: The Next Era of Analytics with Microsoft Power BI