Forum Discussion
Helper IConnect or display data between two diferent organizations/tentants.
The gateway only allows for connection via the Power BI Service. The users will not be able to get access to the data in Desktop, only in the published report.
So you need to publish a dataset, check that it works in the service and let them created reports of that. So publish the report and them ask them to connect to the Power BI dataset from Power BI Desktop:
That way the datasets is connected to your on-prem data and they access it through the dataset.
Advocate IIAre you looking to access data you have on-premise in your organization and expose that to their users? (if so you should simple be able to setup the gateway in your organization and register it with a user from their tenant)
Or are you looking to share actual data already published to your tenant? (this should be possible via B2B sharing, but will require a bit of thought in setting up).
If its general sharing of data perhaps https://azure.microsoft.com/en-us/services/data-share/ is worth a look also.
Helper II'm looking to access data that we have on-premise in our organization and expose it to their users.
I've setup a new gateway in our organization and register it with a user from their tenant, but it was "placed" in the their cluster. When I try to add a new data source I get the following error message:
"Unable to connect: We encountered an error while trying to connect to . Details: We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."
- nsc
Can you try to install the gateway as a 'stand alone' gateway, not sure how it could/would work if its added to a cluster they already have as that would be on a separate network.
With a stand alone gateway it will be the users that is registered that determines the tenant, so it should work fine.
- FGaspar
It worked after creating a standalone gateway.
I was able to create a Data Source from our tenant.
Now I'm facing another problem - although the data source is valid, the users of the tenant cannot connect to this data source in
Power BI Desktop (error message attached):
Please note that I've add permissions to the users for publish reports and use this data source.
- nsc
The gateway only allows for connection via the Power BI Service. The users will not be able to get access to the data in Desktop, only in the published report.
So you need to publish a dataset, check that it works in the service and let them created reports of that. So publish the report and them ask them to connect to the Power BI dataset from Power BI Desktop:
That way the datasets is connected to your on-prem data and they access it through the dataset.