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
NetBoulter
Frequent Visitor

How to run two companies (different domains) with one gateway?

Hello Community Friends

 

We have just (this week) migrated to Azure. At the moment our data sources are csv. I run two companies which have different domains: Company1.co.uk and Company2.co.uk. Up to now I have run two separate gateways, one on a cloud one locally - each run individually under my email for that domain. 

 

We now have one server on a joint cloud. If I link my on premises gateway to my Company1.co.uk email will I be able to use that gateway to link data to my Company2.co.uk dashboards?

 

The data for both companies is held in the same place but previously I had problems sharing data with people not in my domain. Can I add people from Company2 as users to the gateway if it is assigned to my Company1 email account? 

 

Ideally I want to be able to use one on-premises gateway but if I can't what would be your solution? 

 

Many Thanks

1 ACCEPTED SOLUTION

Thanks for your help @v-shex-msft I can confirm that rights can be shared within a single tenant, regardless of the "domain" or upn suffix the user has, however it can not be shared with users on different tenants.

 

The issue we had was that company1 and company2 were seperate tenants, the vanity domain of company2 was moved to company1 tenant, however the dashboards were still in company2 tenant, which could not access company1 gateway.

 

@NetBoulter is now moving the dashboards to company1 tenant and setting up the user rights as required.  So we look all good now!

View solution in original post

10 REPLIES 10
v-shex-msft
Community Support
Community Support

Hi @NetBoulter,

 

>>We now have one server on a joint cloud. If I link my on premises gateway to my Company1.co.uk email will I be able to use that gateway to link data to my Company2.co.uk dashboards?

You can use one gateway to host multiple domain datasource,you should ensure the device which install the gateway can access other domain datasources and has the operate permissions.(prerequisite)

 

>>The data for both companies is held in the same place but previously I had problems sharing data with people not in my domain. Can I add people from Company2 as users to the gateway if it is assigned to my Company1 email account? 

Based on test, you can't add another domain people as the user of gateway.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thank you

 

If I have two sets of dashboards - one for Company1.co.uk and one set for Company2.co.uk - can the gateway be used to feed data to both of those sets of datasets?

 

Many Thanks

Hi @NetBoulter,

 

>>If I have two sets of dashboards - one for Company1.co.uk and one set for Company2.co.uk - can the gateway be used to feed data to both of those sets of datasets?

 

Yes, you can use it.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Unfortunately this does not work.

 

I have my on-premises dashboard registered to myname@company1.co.uk.  

 

My second set of dashboards is registered to myname@company2.co.uk. (I have two separate email accounts)

 

So when I am logged onto Power BI company2 it tells me that I do not have any gateways and invites me to download one. It cannot see the gateway on my computer that is already registered to company1 - because that belongs to someone else.

 

I have to publish my dashboards separately under company1 and company2 because they can only be shared properly with people of the same domain.

 

So unfortunately it appears that you cannot feed two sets of dashboards that live on different domains with the same gateway....

Hi @NetBoulter,

 

It seems like you have some misunderstanding for my description.

You can add multiple data sources from different domain as the data sources of same gateway, but you can't add different domain users to same gateway.(you can only share gateway with same domain users)

 

E.g:

User abc(domain 1) create a dashboard with data source A(from domain 1) and datasource B(from domain 2) with one gateway.(Support)
User a(domain 1) create a dashboard with data source A(from domain 1), user b(domain 2)  create a dashboard with data source B(from domain 2), they want to use one gateway to manage these datasource.(Not support)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi, can I just confirm exactly what we mean by "domain" here please? In this scenario we have just 1 office 365 tenant, however some of the users use an @company1 upn suffix and some use an @company2 upn suffix to log on. Are we saying that the dashboards can only be shared to users with the same upn suffix as their logon, even though they are in the same tenant and therefore the same azure ad domain?

Hi @Jpascoe,

 

You can test to add other users at gateway. If you add him successfully, it means you can share gateway to him.

 

Notice: I test to add a external user to gateway but failed and show the error message "One or more users were not found within your organization".

5.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft 
Aplogies for jumping into this correspondance but was wondering if you can asisst with the following which might be similar.
I have two clients, however, the one is a shareholder and wants to be able to intergrate the 2 reports.
Below pictures of what I currently have and what i would like to achieve:

Axiomite_0-1665743280667.png

From power bi destkop i upload the report created from data on sql server 123.xxx.xxx. 
Once uploaded I click on the data set settings.
It prompts me to install the GW howerver I already have on installed on sql server 123.xxx.xxx.
I try and change the credentials and try to log into GW with admin@domain123.com user name and password (currently on the admin@domain122.com Power Bi Service ). 

Nothing happes when clicking on sign in, its just keeps on spinning. 

Axiomite_1-1665743550427.png

Currently I still have to figure out how to integrate two reports but for now  win would be if the Share holder client could view the report in same domain rather than having to jump between two Power Bi services.

Does it make sense? 

Kind Regards

Thanks for your help @v-shex-msft I can confirm that rights can be shared within a single tenant, regardless of the "domain" or upn suffix the user has, however it can not be shared with users on different tenants.

 

The issue we had was that company1 and company2 were seperate tenants, the vanity domain of company2 was moved to company1 tenant, however the dashboards were still in company2 tenant, which could not access company1 gateway.

 

@NetBoulter is now moving the dashboards to company1 tenant and setting up the user rights as required.  So we look all good now!

Thank you

 

Very exciting - off to try it now...

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.

Top Solution Authors
Top Kudoed Authors