Embed power bi report into app that is getting data from other organization

[MrMP]

Hi,

The request/problem is the following:

We have to embed power bi report in our custom app.
The problem is that report is coming from other organization and their data is sql on premise. Is there a possiblity that we can use gateway in other organization to access the data and embed it in our app?

Or maybe in simpler words, other organization will generate pbix and then it can be embeded into ours custom app and auto refreshed using their gateway.

Hope you guys have some ideas!

Thank you!

[Adamboer]

Yes, it is possible to use a gateway in the other organization to access the data and embed the Power BI report in your custom app.

To achieve this, you would need to follow these steps:

1. Request access to the data source from the other organization.
2. Install an On-premises data gateway in the other organization.
3. Configure the gateway to access the data source in the other organization.
4. Create the Power BI report in the other organization and publish it to Power BI service.
5. Embed the Power BI report in your custom app using the Power BI embedded API.
6. Configure the report to use the gateway in the other organization for data refresh.

Note that you would need to work closely with the other organization to ensure that the data source is configured correctly and that the necessary security measures are in place. You would also need to have a clear understanding of the data access requirements and any restrictions on the use of the data.

[MrMP]

Thank you for your help. This did help a lot!

Since this will be a lot of customers with different sql systems, is there any solution that will not require all them to install gateway? Maybe a central cloud database to collect all data via whitelisted ip from different sql systems?