Thursday, May 18, 2017

Power BI Report Server–Trial

I just installed the Power BI report server following @SQLDusty YouTube 13 minute Step-by-Step video. You have to download both the Power BI Report Server and a new Power BI Desktop. Once installed, it is easy to get your Power BI Report onto the Server if it is developed on the same machine/server as the Power BI Desktop. But it took me a little while to get a Report published from my client machine to out development server.


In the upper right of managing the Power BI Report Server, there is a menu for Manage folder. Here, we needed to add my domain ActiveDirectory Account to the Content Manager role.


Once I did that, the Power BI Report created on my client could get Deployed/Published. Or, maybe I should say Saved As. Yes, to save the report from Power BI Desktop, you got to go to the File/Save As… menu to post to a Power BI Report Server. You do not Deploy or Publish. Kinda of wierd, but it works.

Then, you are prompted for the ReportServer name.


If you click OK and get an error, you do not have permissions. Go to the Manage Folder in the Power BI Report Server and add your AD account as a Content Manager,


When you have permissions…


Thursday, May 11, 2017

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov 3rd. Oct 30th and 31st are for pre-conference sessions (all day workshops) and this year there is no open call for these sessions. Not sure the selection process because it seems to be behind the scenes, but apparently feedback from attendees is driving a change in quality and content.

PASS Summit 2017

Here is a link to the Call For Speakers. It has been a blessing to have spoken at the last 6 Summits and attending 9 out of the last 10. There is so much to take in at a PASS Summit, and it took me about 3-4 years to learn how to make the most out of this conference.

The Summit tracks have changes, so go here to get the list. The open call for speaker closes on May 24th, so get busy with your submissions. There is also a limit of 3 session submissions and only for the 75 minute and 10 minute Lighting Round.

The Speaker Resource page is a great area of information about speaking at the Summit. There is even a Submitted Sessions page, once you login in, to see what has already been submitted.

You can also go to the Blog page of the site to see board members explain the new speaker selection process.

Saturday, April 22, 2017

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users


Thu, Apr 27 2017 20:00 GMT Daylight Time

Power BI Dashboard within an hour for Excel users


Power BI Dashboard within an hour for Excel users

If you are an experienced Excel user or Someone in your organisation mentioned about Power BI and you want to understand what you can do with it, then this session is for you. In this demo-focused session, Prathy will show how one can extract, transform, analyse and visualise the data using Microsoft Power BI. She will give a quick introduction to different features of Power BI, some of them are similar to Excel, and some are pretty new relate to Excel. Prathy will also talk about resources More...

Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London. She specialises in Power BI, SSIS, SSAS and SSRS. Prathy organisers London Power BI user group and co-organises London PASS Chapter. She is a regular speaker at events like SQL Saturdays and local user groups.

Wednesday, April 19, 2017

SQLShack Arcticle and Upcoming PASS Events

The latest article on SQLShack continues on the path of Data Warehouse development with SQL Server Analysis Services. The first step after designing the Data warehouse is conneting to the Data Source. All good DW implementations have a central database to store the data. Analysis Services is a great tool to centralize the business logic (or intelligence) - Connecting to Data Source(s) with SQL Server Analysis Services

Upcoming PASS Events

24 Hours of PASS – 24 back to back session June 29th-30th 2017

BA Marathon Recordings – Business Analytics last virtual sessions

Virtual Groups

Streamline SQL Implementations - Prakash Heda

In-Memory OLTP - What can it do for me? - Martin Catherall

Effortless Backups with Minion Backup - Jennifer McCown

Initial impressions of SQL Server v.Next Public Preview - Haidong Ji

Indexes: Everything You Wanted to Know -- Help or Hinder - Mike Byrd

ColumnStore Index in SQL Server 2016 and Azure SQL Database - Sunil Agarwal




SQLSaturday #594 - Edmonton 2017



SQLSaturday #621 - Silicon Valley 2017



SQLSaturday #623 - Israel 2017



SQLSaturday #598 - Costa Rica 2017



SQLSaturday #607 - Calgary 2017



SQLSaturday #619 - Rochester 2017


Tuesday, March 21, 2017

SSIS Articles on SQLShack

Please check out for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package or packages. The parameters are at the project level so you only have to change them once to effect multiple packages.

I use a simple example like changing the database name and server (instance) name for the Project level Connection Manage WHICH is another big change for SSIS. Starting in 2012, you can share connections among packages in a project. Enjoy!!!

Parametering Database Connection in SQL Server Integration Services

Deploying Packages to SQL Server Integration Services Catalog (SSISDB)

How to execute a Deployed Package from the SSIS Catalog with various options

Friday, March 17, 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session at or

Featured Presentation:  Improvements to Excel Pivot Tables
Alexander Lahuerta, Program Manager Microsoft

The Excel team is working on several interesting new features to Excel. Join us to take a look at some really interesting improvements to Excel that are soon to be released.

About Alexander:
I’m a Program Manager on the Excel Team at Microsoft. I’ve been here for three and a half years. For the past two years, I’ve been diving deep into Business Intelligence and making it easier for people to dig into their data. I want you to love PivotTables as much as I do.

Wed, Mar 22 2017 15:00 (UTC+00:00) Dublin, Edinburgh, Lisbon, London

Improvements to Excel Pivot Tables


Thursday, February 23, 2017

Upcoming PASS Events

There is a new website from PASS. Go to instead of The change does not really concern me but marketing is something I am not into…yet!!!

The one thing I do like is the formatting when viewing on a mobile device. That is very nice. Here is what I found coming up in the PASS community.


BA Marathon – Business Analytics

There will be six back-to-back live webinars and the next BA Marathon will be spring 2017.

While you wait, why not access recordings from previous Marathons?


Here are some Virtual Chapter Recordings

SQL Server DBA Tips That Can Save Your A$$ -- Part 2 - Guy Glantser

Implementing New Security Features in SQL Server 2016, Part 2 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Why Your Data Type Choices Matter - Andy Yun

Implementing (and cracking) new Security Features in SQL Server 2016, Part 1 – sponsored by Hewlett Packard Enterprise - Ronen Ariely

Take Power BI Visualizations to the Next Level - Reza Rad

Azure SQL Database Elastic Pool – introduction and usage scenarios – sponsored by Hewlett Packard Enterprise - Kun Cheng

How SQL Server 2016 SP1 Changes the Game - Parikshit Savjani

Advanced Power BI: Solving the Hard Problems - Devin Knight

An (Advanced) Introduction to DAX - Eugene Meidinger


Here are some upcoming SQLSaturdays

25 FEBRUARY - SQLSaturday #585 - Boston 2017


25 FEBRUARY - SQLSaturday #589 - Pordenone 2017


25 FEBRUARY - SQLSaturday #596 - Denver - BI Edition 2017


04 MARCH - SQLSaturday #603 - Dallas - BI Edition 2017


11 MARCHSQLSaturday #583 - Lisbon 2017


11 MARCH - SQLSaturday #592 - Raleigh 2017


11 MARCH - SQLSaturday #600 - Chicago 2017