Report Model managment is discontinued in Reporting Services Web Portal

RS Web Portal is the new name for Report Manager of earlier versions.

The following two features related to Report Model are discontinued  in SQL Server 2016.
Whereas HTML4 is supported, the future SQL Server Reporting Services will be using HTML5.

Feature                                                                Replacement or workaround
Upload report models through the web portal     This can still be done through the SOAP API.
Manage report models through the web portal    This can still be done through the SOAP API.

However the Report Model is still retained in couple of places, for example the Window for selecting permissions for a Custom Role.

Connecting to SQL Server 2016 from Power BI

 Most of the SQL Servers have an integrated Reporting Services, a stable work horse for not only turning out reports but also handling all aspects of enterprise reporting from getting data to distributing, monitoring, etc. It has a reporting services Report Server and an integrated Report Manager front end.

I have covered the Reporting Services in two of my more popular books, one for SQL Server 2008 and another for Reporting Services 2012. The latter covers both the Native Mode of the server but also the SharePoint Integrated mode.





 

PowerBI on the other hand is supposed to provide the ad-hoc authoring of reports even though the author of the report has the knowledge of neither the complete innards of the report data nor the programming capabilities of a full-blown report developer.

In this post, I will step through the process of connecting to SQL Server 2016 from one of the recent versions of Power BI. I have a number of posts for the interested reader related to Power BI at the conclusion of this post.

The details of this post relates to a Windows 10 laptop which has a local named instance of SQL Server 2016 (Developer edition) and Power BI.

Step 1:
Launch POWER BI from its desktop shortcut.

PowerBI_00

Step 2:
Make sure your SQL Server 2016 is up and running. Get to the main screen where you will be designing by dismissing the modal splash screen.

PowerBI_01

 Click on GetData. You should get a drop-down menu with various data sources listed. When you hover over SQL Server you can see the pop-up as shown.

 PowerBI_02
 Click on SQL Server to display the following:

  PowerBI_03
You need to enter the details. The present version is not showing any options to browse for a server. You need to enter (You can get the information from the SSMS 2016) the details, the one shown are for the present named Instance of SQL Server 2016.

 

PowerBI_04

Click OK and you will be displaying the following screen:

 

PowerBI_05


SQL Server 2016 was installed for Windows Authentication access and therefore you can accept the default and click Connect.

You get this message related to encryption. SQL Server 2016 supports encryption and I am not sure why this message generated.

PowerBI_06

Click OK and you are connected to the AdventureWorks2014 Database as shown.

PowerBI_07

You may want to read up on the following related stuff to get a head start with Power BI:

PowerBI and the Cloud
http://hodentek.blogspot.com/2015/08/doing-bi-in-cloud-using-powerbi-for.html

PowerBI on Gartner's Magic Quadrant
http://hodentek.blogspot.com/2015/07/qlik-is-in-gartners-bi-magic-quadrant.html

Report from SQL Anywhere 16 using Microsoft Power BI
http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql.html

Report from an EXCEL application
http://hodentek.blogspot.com/2015/02/powerbi-preview-reports-using-data-on.html

Rapid reporting with Microsoft Power BI
http://hodentek.blogspot.com/2015/02/spin-out-cutting-edge-report-with-power.html

Microsoft Intelligent System Services
http://hodentek.blogspot.com/2015/03/microsoft-azure-iot-services-update.html

Power BI Unchained
http://hodentek.blogspot.com/2015/02/power-bi-unchained.html

Problem with SQL Server 2014 Report Builder 3 and the fix

This problem surfaced while installing SQL Server 2104 Report Builder on a Windows 10 (x64) Pro machine which has a SQL Server 2014 (x64) Developer Edition installed and a properly configured Report Server.

The Report Builder software was downloaded from this Microsoft Site:
https://www.microsoft.com/en-us/download/details.aspx?id=42301

ReportBuilder_01

Double clicking the downloaded MSI file above started the installation. The program looks for a target report server and it was provided as shown:

ReportBuilder_02

The Report Server and the Report Manager both do not have any problem. However this ends up with an unsuccesful installation with this message:

ReportBuilder_03

The work around for this is to not provide a target report server and ccontinue with the installation. The installation succeeds this time. After a little while an gets added to the All Icons group as shown.

ReportBuilder_04

Hands-on Learning Event in Honolulu 2, Nov 5, 2015: SQL Server Reporting Services 2012

The class is forming and is expected to start on November 5, 2015. Please register at the PCATT.ORG site.

Adata/Pcatt1.png
SQL Server 2012 Express or Developer Edition / Evaluation edition will be used. The emphasis is on Native Mode operation of the Reporting Services.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

Hands-on Learning Event in Honolulu 2: SQL Server Reporting Services 2012

The class is forming and is expected to start in August 2015. Please register at the PCATT.ORG site.

SQL Server 2012 Express or Developer Edition will be used.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

 

 

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

 

 

Hands-on learning event in Honolulu -SQL Server Reporting Services 2012

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific center for Advanced technology Training: http://pcatt.hawaii.edu/home

Report writing is one of the most important IT related jobs in an enterprise. This course if for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises. At the end of the course you will have gained:
• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.


Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598 Phone: (808) 845-9211
Official Website: honolulu.hawaii.edu/

Section 1 - Mar 31 - May 7, 2015; TTh; 5:30 pm - 8:30 pm; 12 mtgs

I will be using my latest book on SQL Server Reporting Services for this course:

 

More here:http://hodentekmsss.blogspot.com/2014/11/things-you-learrn-hands-on-in-my-book.html

 

Regarding my books on Microsoft Business Intelligence

Regarding the books

This app (which also happens to be my first app) brings together details of my Microsoft Business Intelligence related books from 2007 to 2014 based on the numerous articles I wrote to various online forums from 1996 to 2006. The focus of all these books is really Microsoft SQL Servers and Microsoft Visual Studio programming IDE. Also the books were written so that even beginning level readers can profit a great deal so that their learning is accelerated.

The first book on SQL Server Integration Services Using Visual Studio 2005 provides you with a basic knowledge you should have before you move on to more advanced topics. It is a step-by-step, hands-on guide that takes you directly to the Visual Studio IDE where you learn to work with projects rapidly and efficiently. You get the first hand experience of connecting to various data sources and transform them in many ways.

 

The second book Learning SQL Server 2008 Reporting Services is ideal for beginners who want to spin-out reports from a variety of data sources and deploy them to report servers. The book is replete with step-by-step, hands-on exercises where the users can hone their skills.

The third book Microsoft SQL Azure: Enterprise Application Development was written at the time Microsoft seriously entered the Cloud Arena. Microsoft took its flagship SQL Server Technology to the Azure Cloud. The books gives you a comprehensive knowledge of how to work with SQL Azure in the cloud from scratch to finish.

The fourth book Microsoft Visual Studio Lightswitch Business Application Development is a jump start, step-by-step guide to take your data out of data sources and present them to the stake holders be it on desktop; the web or the Cloud. The book does not require prior knowledge of VS Lightswitch or Visual Studio.

The fifth book Learning SQL Server Reporting Services 2012 is a revised edition and a deals with both Native and SharePoint Integrated modes of Report Servers. This covers every aspect of the first edition(second book) with lots of added material to include development in the intervening years.

 

As the author of these Microsoft Business Intelligence related books I have great confidence in their usefulness. I would love to hear from you. Email me at: hodentek@live.com.

SQL Training in Honolulu: SQL Server Reporting Services 2012

This is a comprehensive, hands-on course. The above course will be offered as a non-credit course by the Pacific Center for Advanced Technology Training

 Course summary:
SQL Server Reporting Services 2012
Report writing is one of the most important IT related jobs in an enterprise. 
Among the BI stack components the component that provides most employment is Reporting 
Services.

This course is for you if you would like to master report writing/authoring 
using SQL Server Reporting Services. The course begins with a presentation of 
essential technical background, after which you will work through guided 
hands-on exercises.

You will start off learning the details of installing SQL Server 2102 
Developer edition and configuring Native mode Reporting Services. For 
authoring reports and interacting with reporting services you will also learn 
how to install and work with Report Builder 3.0. This is essential for 
deploying authored reports to report sever.

Report Manager the web front end is an essential part of Reporting Services 
2012 and you will learn a comprehensive set of tasks that you can carry out.
A working knowledge of Report Manager's ability to carry out administrative 
tasks related to all aspects of reports; creating shared data sources, folder 
and folder hierarchies on the report server, and report models; managing 
security and subscriptions; and configuring data driven subscriptions is 
essential for managing reports.

Many applications depend on embedding these reports so that the user has the 
opportunity to view these reports. To this end, an understanding of how to 
embed report viewer controls in windows and web projects is essential. You 
will learn the basics of creating these applications.

During each meeting the students will be assessed for their knowledge, 
competency and proficiency in installing, configuring, authoring, deploying, 
and managing reports.

The hands-on exercises will draw largely from the authors first and second editions of his book on SQL Server Reporting Services 2012.

 

and the first edition related to SQL Server 2008

 

Course schedule: 

Feb 3 - Mar 17, 2014; Mondays and Wednesdays; 5:30 pm - 8:30 pm; 12 meetings

Location:
Honolulu Community College

Training Course in Honolulu: SQL Server Reporting Services 2012

This hands-on course will provide you with the ability to create cutting edge reports using Microsoft's latest reporting services product, SQL Server 2012.

The course is offered by the Pacific center for Advanced technology Training: http://pcatt.hawaii.edu/home

Report writing is one of the most important IT related jobs in an enterprise. This course if for you if you would like to master report writing/authoring using SQL Server Reporting Services. The course begins with a presentation of essential technical background, after which you will work through guided hands-on exercises. At the end of the course you will have gained:
• A solid understanding of how to interact with SQL Servers
• Knowledge and experience installing and configuring reporting Services
• A working knowledge of using Report Builder to author reports and deploy them to report server
• A working knowledge of Report Manager's ability to carry out administrative tasks related to all aspects of reports; creating shared data sources, folder and folder hierarchies on the report server, and report models; managing security and subscriptions; and configuring data driven subscriptions
• An understanding of how to embed report viewer controls in windows and web projects.

Course code: 134F1TSQL003A

Venue: Honolulu Community College Honolulu Community College
874 Dillingham Blvd Honolulu, HI 96817-4598 Phone: (808) 845-9211
Official Website: honolulu.hawaii.edu/

Section 1 - Nov 6 - Dec 16; MW; 5:30 pm - 8:30 pm; 12 mtgs.

I will be using my latest book on SQL Server Reporting Services for this course: