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.

Cenk's avatar
Cenk
Regular Visitor
4 years ago

Thank You for the information Ibendlin.

What if I send the data in MySql to Cloud like Azure.

Can I use it like:

1 : Excel File in Location 1

2 : MySql Database in Azure

One source from on premises gateway and the other source from Azure or another cloud location.

Thanx in advance.  

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

Hi Cenk ,

 

As far as I know, a gateway is also required for Azure MySQL, but Azure SQL Server which supports the connection Power BI without having to use the gateway in between.


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