Forum Discussion

Cenk's avatar
Cenk
Regular Visitor
4 years ago
Solved

Data From Multiple Gateways

I really need help about my powerBI project. I have four data sources in two different locations. 1 : Excel File in Location 1 2 : MySql Database in Location 1 3 : Excel File in Location 2 4 : M...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Yes, you can go even further. If Location 1 is a Onedrive then you don't need a gateway at all.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi Cenk ,

 

According to your description, are you using a personal mode gateway?You can have only one personal mode gateway running for each Power BI user.

You can create high-availability clusters of gateway installations.

After you create a cluster of two or more gateways, all gateway management operations apply to every gateway in the cluster. These operations include granting administrative permissions to a gateway and adding data sources or connections.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gateway-to-create-a-cluster 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.