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.

jotaandres's avatar
jotaandres
Helper I
9 years ago

Hi,

 

I have the same problem. I have a report which is pulling data from salesforce. It was refreshing fine (no need for a gateway). Then I had to add to the data model a custom table from an on_premise SQL server. Now the gatway (which s working for other reports pulling data only from the SQL server), doesn't appear as an option to chose to refresh the data.

 

According to the comments above, this is a gateway problem. It is suppoed to be used with only one server as a datasource? It doesn't make too much sense. Let's see what Microsoft has to say about it.

 

Jojrge

jotaandres's avatar
jotaandres
Helper I
9 years ago

I found the answer to my problem trying to combine salesforce and an on-premise database.

 

"

Warning:

If one of your data sources requires OAuth authentication, you will not be able to configure it with the On-Premises Data Gateway. OAuth authentication is not currently supported with the On-Premises Data Gateway. You will need to remove the data source that requires OAuth authentication from Power BI Desktop in order to configured scheduled refresh.

"