cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sumsar Frequent Visitor
Frequent Visitor

External content distribution

Hi,

 

We have an Azure SQL Server running with 50 databases on it, each representing one of our customers' data. New customers onboarding on a regular basis. The structure is the same between these databases. On top of the databases we want to build a standard Power BI App or Content Pack in a way, that we can just onboard a customer by sending them user name and password for their respective database, then they can go grab the app from powerbi.com, being prompted for the aforementioned credentials and see the standard reports in the app based on their own data.

 

Basically a one source, multiple (external) users scenario, but with users outside our organisation.

 

On a more technical side node, three parameters needs to change per customer; database name, user name and password. The database name however, is the same as the user name.

 

I would like to see some recommendations for how to solve this scenario.

 

Thanks alot.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: External content distribution

@Sumsar Aside from the technical challenges of this, you will likely want to reach out to your local MSFT rep and walk them through your offering. There is a sticky point around sharing externally (fine and covered by licenses) vs. assuming the role of providing Power BI as a Service... which needs special permission to do because in essence you are assuming the role of MSFT assigning those licenses.

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2
Super User
Super User

Re: External content distribution

@Sumsar Aside from the technical challenges of this, you will likely want to reach out to your local MSFT rep and walk them through your offering. There is a sticky point around sharing externally (fine and covered by licenses) vs. assuming the role of providing Power BI as a Service... which needs special permission to do because in essence you are assuming the role of MSFT assigning those licenses.

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Sumsar Frequent Visitor
Frequent Visitor

Re: External content distribution

Thanks Seth,

 

I cleared that with my local office and I will go with a single DB and RLS scenario.

 

Br Rasmus

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)