Skip to main content

Microsoft Business Central Implementation: The Story So Far

Tips For a Successful Power BI Report Server Implementation

What is the Power BI Report Server

Power BI Report Server provides a unified approach and knowledge for those BI Analysts eager to use all the varied reporting options that Microsoft makes available in their Business Intelligence suite. It combines the normal paginated reports from Reporting Service with KPIs, Mobile Reports, and Power BI dashboards and reports. The key here is of these options are available on-premise which provides you the power to stay “your” data and related reports in-house.

Power BI Report Server (PBIRS) may be a superset of SQL Server Reporting Services (SSRS), itself a mature BI technology that has been a key component of the Microsoft BI stack for 15+ years. The main difference between the 2 platforms is that PBIRS brings with it Power BI reports, providing a contemporary BI experience to on-premises implementations.

As is that the case with any enterprise BI product, careful planning and consideration of how the technology are getting to be leveraged should be made up-front. This will help avoid speed bumps during implementation and ensure a smooth ride as you roll out your BI and analytics solutions. Whether you’ve been working with PBIRS from day one, or are beginning to use the platform for the primary time, the goal of this post is to showcase tips and techniques that you simply can rotate and apply in your own environment.

Configure Your Report Server

After installing your report server, you ought to consider reviewing a number of the default configurations. We’re not pertaining to configurations found within the Reporting Services Configuration Manager, but rather the advanced properties you'll tweak from within SQL Server Management Studio (SSMS). For many implementations, the default values of those properties are going to be fine. However, there could also be some specific use cases for once you would want to vary a setting. The advanced properties in PBIRS are like Power BI Service’s tenant settings within the Admin portal.

First, to look at the advanced properties dialog, you would like to attach to your report server from SSMS.

From Object Explorer select Reporting Services.

Enter your credentials to attach to your report server.

Right-click on your instance name and select Properties.

The Server Properties panel will appear; select Advanced on the left-hand pane.

From the advanced properties menu, you’ll notice an entire host of options you'll toggle. Below are three specific properties that we've modified for a couple of our customers’ implementations.


This setting is disabled by default, but many organizations like it better to enable this. The feature will provide every report server user with their own dedicated folder on the report server. This is almost like the My Workspace concept that users have within Power BI service. Enabling My Reports is a great way to encourage self-service BI.


This setting allows you to toggle what percentage days of report execution history are stored within the underlying ReportServer database. The default is 60 days. Increasing this value will collect more metadata, thus allowing you to research adoption over time. We mention how you'll monitor your report server.


This setting tells PBIRS what level of detail users can export data from a visual. In our experience, exporting underlying data can cause major performance bottlenecks if you’re not careful. This is very true if the underlying model is large (both in terms of knowledge and attributes/measures). For this reason, we encourage customers to disable this setting. Most of the time users will simply be happy to export the data that they see within the visual they're exporting from.

Why use Power BI Report Server

Using Power BI Report Server is that the next evolution for Business Intelligence tools and reporting, and it's definitely aimed toward the visualization market and competitors like Tableau and Qlik. Where Power BI Report Server excels is certainly associated with Microsoft's strong existing presence with SSRS, SSAS, and SSIS and therefore the big variety of knowledge sources available in Microsoft Power BI Implementation.

Additionally, the Power BI Report Server provides a rich, HTML5 reporting portal and a portal for all your reporting needs.

Furthermore, Power BI Report Server allows for branding the portal to match your organization’s branding, color, and logos.

Moreover, this version of the Reports Server allows report consumers to simply store Excel files which may successively be used as a knowledge source for other reports components.

Of course, the facility BI Reports element provides the rich interactive features that are being requested by modern report consumers. Finally, the facility BI Report Server gives you an avenue to use APIs as a conduit to utilize custom reporting solutions.

Who can use Power BI Report Server

Here is where Microsoft sets the parameters for having the ability to use Power BI Report Server. As a developer, you'll certainly use the developer edition to experiment and test the features. However, to use Power BI Report Server and every one its functionality in production, you want to have access to Power BI Premium. Power BI Premium includes many other benefits additionally to Power BI Report Server.

Furthermore, to really enjoy the rich features of Power BI Report Server, you are doing got to use what Microsoft calls a contemporary browser. This generally means you would like to be using the newest or near latest versions of the foremost common browsers. The good news is that it supports many of the browsers that were only marginally supported in past versions. The list includes:

IE 11
When can I use Power BI Report Server?
The simple answer is now. To get started, a developer edition is out there to be used during a testing environment and is that the perfect thanks to starting using Power BI Report Server. To know more about Microsoft Power BI Implementation-


Popular posts from this blog

Microsoft Business Central Implementation: The Story So Far

  Microsoft Dynamics 365 Business Central has proven itself since its initial launch as one of the finest Microsoft Business Solutions . ERP users easily recognize it in its previous avatar, which was of the NAV and though it retains all the key features of NAV including the same application code as well, Microsoft also offers the solution a cloud-based operable in the heart of Microsoft’s intelligent cloud. For those who have still not gotten a Microsoft Business Central Implementation done, given below is what they stand to gain after getting one done: Finance : BC (Business Central’s short form) connects data across sales, accounting, purchasing, stock and customer transactions to help businesses take better and wiser decisions. It has Power Bi dashboards that let the end user track financial performances in real-time and identify patterns and trends emerging in business through comprehensive reports and analysis. The solution helps improve forecasting through comprehensi

What is email marketing? How does it help business?

Email marketing has been around forever, and for good reason. It’s the most direct and effective way of connecting with your leads, nurturing them, and turning them into customers, consistently winning out over all other marketing channels. Email marketing is a digital marketing strategy based on sending emails and developing relationships with prospects and customers. An effective email marketing strategy convert prospects into customers, and turn first time buyers into recurring customers. One advantage of email marketing is that you can automate the entire process. Remember – You are a guest in their inbox People are inundated with interruptions, pitches, and advertisements everywhere they look. Though you might think your email is special, there’s a high probability that to the reader, it looks the same as the rest. This is why it’s important to remember where you are, and use your good manners as a result. Does email marketing still work? We know email marketing still works in ter

Benefits of taking Lead Auditor Certification in Quality, Safety and Environment.

Benefits of taking Lead Auditor Certification in Quality, Safety and Environment. There is a tremendous demand for Lead Auditor certified professionals. 1. Companies prefer Lead Auditors for Quality, Safety, and Environment jobs. 2. Salaries of Lead Auditors in Quality, Safety & Environment are more than other non-certified persons. 3. Certified Lead Auditor can join an auditing company as a Trainee Auditor and become Lead Auditor. 4. Working Engineers in Quality, Safety & Environment can get Senior Engineer positions. 5. Working Quality, Safety & Environment Engineers learn auditing techniques for performing Internal Audits and Sub-Contractors audits for all 3 management systems. 6. Major techniques for Conducting    a) Third Party Audits    b) Second Party Audits    c) Internal Audits are taught 7. Detailed knowledge of the ISO Standards is imparted for the following Systems          ISO 9001  QMS Quality          ISO 45001 OHSMS Safety          ISO 14001 EMS Environment