Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dli9
Frequent Visitor

Do I still need a Pro/Premium license if I have a Report Server subscription?

I'd like to share my dashboards with internal members of the department but was told by my organization head that sharing permissions can't be granted to me because this isn't a feature. They also mentioned they only support SQL connections, but I'm not sure if they have a SQL Enterprise license as part of the report server subscription. From what I've seen, it looks like dashboards are being shared internally (members log in via their company credentials to view the dashboards). 

 

If I have the report server subscription, do I still need a pro/premium license to share dashboards? 

 

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @dli9 ,

 


Are you able to share the dashboard with members outside the organization if you went with the SQL enterprise license? 

In this scenario, to enable external users access, you can configure Custom Authentication or use ADFS as proxy.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
dli9
Frequent Visitor

@lbendlin Are you able to share the dashboard with members outside the organization if you went with the SQL enterprise license? My head insists we don't have sharing capabilities even though everyone in the organization can see the published dashboards (unsure about people outside). They've requested I send them the dashboard and data for them to upload, so I'm confused on why they can't give me publishing access if this feature exists (how are they uploading if there are no sharing/publishing capabilities?)

Icey
Community Support
Community Support

Hi @dli9 ,

 


Are you able to share the dashboard with members outside the organization if you went with the SQL enterprise license? 

In this scenario, to enable external users access, you can configure Custom Authentication or use ADFS as proxy.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dli9
Frequent Visitor

@lbendlin I understood it as if an organization has premium then external users (outside the org) would NOT need a pro license. 

Icey
Community Support
Community Support

Hi @dli9 ,

 

So what are you using to share reports to external users? Power BI Service or Power BI Report Server

 

In addition, for allow users from other domains to access PBIRS, you may refer to this:


 

In Reporting Services, if we want to access Reporting Services from other domain, we should apply domain trust or do extranet deployment. It will be considered as “same” domain to SSRS so that users from a trusted domain can access Reporting Services. And when the outer domain user access the current domain, they need to provide the credential.

Here is an official documentation about Extranet or Internet Deployment.

Follow the steps and then we could successfully put Reporting Services on an Internet-facing Web server to distribute general information to the public at large or private corporate data to authorized and authenticated users.

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159272(v=sql.105)

Set different domain as trust domain and then grant the external user permission.
https://www.oreilly.com/library/view/active-directory-cookbook/0596004648/ch02s18.html
https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2003/cc775736(v=ws....

Reporting Services provides an extensible architecture that allows you to plug in custom or forms-based authentication modules. The most common scenario for using custom authentication is to support Internet or extranet access to a Web application.

For more information, please refer to the article below:

https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-custom-or-forms-authentic...

 

Reference: How to share external user my SSRS reports(My data source is Azure DB) - Microsoft Q&A

 


 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey
Community Support
Community Support

Hi @dli9 ,

 

Any feedback?🤔

 

 

Best Regards,

Icey

If you are on Premium then internal users (users within your AD)  do not need a Pro license if you share the apps.  Users outside of your AD do need a Pro license if you share content with them.

My (limited) understanding of external sharing is that you have to do a Premium Capacity and the external users have to have Pro licenses.

lbendlin
Super User
Super User

I think there are two ways to get a Report Server license - either you have a SQL enterprise license, or a Power BI premium capacity.  Both come with complementary report server.

 

Not sure what your organization head is alluding to - maybe they were thinking Premium capacity?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.