Forum Discussion

siacc's avatar
siacc
Advocate II
9 years ago
Solved

Power BI Gateways with data from two different sources

Hi all, suppose you had two report published on Power BI Service with data becoming from different databases. So, the scenario on Power BI Service is the following:   1) There is a Report, we cal...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    It will refresh the data. Should not matter that there are 2 databases involved. I have refreshed models from 5 or 6 different on-premises sources.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

It will refresh the data. Should not matter that there are 2 databases involved. I have refreshed models from 5 or 6 different on-premises sources.

siacc's avatar
siacc
Advocate II
9 years ago

Greg_Deckler: Have you also tried to refresh two or more reports with data becoming form databases located in different servers? I forgot to ask this question :smileywink:

  • perpor's avatar
    perpor
    Helper V
    9 years ago

    I can't do this because there is, apparently, a problem before, with the gateways.

    (I have a Ticket open and many posts here, but without response at the moment)

    For all the reports ponting to the second database, on the second server, PowerBI does not recognise the gateway, (the second gateway, on the second server, I suppose), you can find many post here without response...

    For the reports pointing to the first database, on the first server, and with the first gateway, no problem.