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.

lbendlin's avatar
lbendlin
Super User
4 years ago

Correct, any Power BI dataset can only be refreshed through a single gateway cluster.  What you are trying to achieve is impossible to do with gateways.  Use a single gateway cluster,  shared datasets or dataflows instead.

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.  

  • lbendlin's avatar
    lbendlin
    Super User
    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 ,

     

    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.