patternsqlModerate
SSRS 2016 Report Portal - KPI option no available in drop down
Viewed 0 times
ssrsavailableoptionreportdropdownportalkpi2016
Problem
Is there a way to enable the KPI selection in reporting services 2016 web portal?
I eagerly wanted to try this feature, I then wasted 2 hours looking for it, still haven't found it. In most examples it seems to be under the "New" drop down.
I'm on the home portal page , I did create a dataset and datasource. Still no KPI option. I've remoted onto the host server, the user has System Administrator and System User rights in SSRS.
I eagerly wanted to try this feature, I then wasted 2 hours looking for it, still haven't found it. In most examples it seems to be under the "New" drop down.
I'm on the home portal page , I did create a dataset and datasource. Still no KPI option. I've remoted onto the host server, the user has System Administrator and System User rights in SSRS.
Solution
KPIs are an Enterprise feature. They are only available in the Enterprise and Developer Editions. https://msdn.microsoft.com/en-us/library/mt742500.aspx
You will also need to do two things in order to have KPIs show up in the "New" dropdown.
Keep in mind local admin isn't a privilege/role. I set up my own SSRS 2016 instance. But I still needed to add my self(and the admin group) to the Content Manager role.
You will also need to do two things in order to have KPIs show up in the "New" dropdown.
- You must have Content Manager or Publisher privileges in the folder you will be creating the KPIs in.
- You must have at least Browse privileges to a shared data source and shared data set. These do not have to be in the same folder as where you want to publish the KPI.
Keep in mind local admin isn't a privilege/role. I set up my own SSRS 2016 instance. But I still needed to add my self(and the admin group) to the Content Manager role.
Context
StackExchange Database Administrators Q#151138, answer score: 10
Revisions (0)
No revisions yet.