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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
MrMP
Helper III
Helper III

Refreshing report in our tenant using sql from other organization

Hi,

 

We have report in our organization that is using on prem data of other organization. Right now, report refresh is manual.

What is the best aproach to make this automatic refresh using power bi gateway?

Thank you!

1 ACCEPTED SOLUTION

You can't use a gateway from another tenant. Gateways are sync to a tenant. You won't find a way to manage or configure sources for gateway unless it was installed with your tenant email. That doesn't mean you can't reach the data. You just need a VM with visibility to the data and install a new gateway with @company1. 

I hope that helps.


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

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
MrMP
Helper III
Helper III

@ibarrau Thank you!

my account is email@company1.com and can company2 share their gateway with me so I can use it to connect to the premise data or I have to have an account in their tenant?

You can't use a gateway from another tenant. Gateways are sync to a tenant. You won't find a way to manage or configure sources for gateway unless it was installed with your tenant email. That doesn't mean you can't reach the data. You just need a VM with visibility to the data and install a new gateway with @company1. 

I hope that helps.


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

Happy to help!

LaDataWeb Blog

ibarrau
Super User
Super User

Hi. Yes. Using an OnPremise Data Gateway Standard mode would be the best approach. Install the gateway in a VM/Machine that has visibility of the database. Be sure the machine will be on when the refresh runs. 

The account installing and logging the gateway will have the administration at Power Bi Service. Open Power Bi Service and configure the database source. Then you can open the schedule refresh of the dataset to check the source and configure the schedule.

Here you have an example with old pictures: https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors