cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
siacc Frequent Visitor
Frequent Visitor

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 call it "Report 1", with data becoming from a database that we call it  "DB 1";

2) There is another Report, we call it "Report 2", with data becoming from a different database that we call it "DB 2".

 

If you install Power BI Gateway (Personal or Enterprise), what will be the behavior when you set the scheduled refresh?

 

Thank you in advance for your answers.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Power BI Gateways with data from two different sources

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Power BI Gateways with data from two different sources

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

perpor Member
Member

Re: Power BI Gateways with data from two different sources

ok, but only if the databases are on the same server, I suppose..

siacc Frequent Visitor
Frequent Visitor

Re: Power BI Gateways with data from two different sources

@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 Smiley Wink

perpor Member
Member

Re: Power BI Gateways with data from two different sources

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.

jotaandres Regular Visitor
Regular Visitor

Re: Power BI Gateways with data from two different sources

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 Regular Visitor
Regular Visitor

Re: Power BI Gateways with data from two different sources

Hi,

 

I just finished another test, and apparently the gateway (on-premises) doesn't work for two databases on the same server. I might be doing something wrong but still it is not working. The work-around I discover is expailn below:

 

So I have DB1 and table1 and DB2 and table2. These DBs are in the same server (SQL server). So I'm bringing table1 from DB1 using the native power BI (Power Query type), apply the transformations and all I need. For table 2, what I do is to bring the tae via query using

 

select * from DB2.dbo.table2 and then apply all the tranaformations/filters I need.

 

Since the defult DB on the gateway configuration (which is needed) is DB1, now the gateway shows up when scheduling the refresh for this report.

 

If somebody has an advice on how to configure the gateway to accept data from mutliple databases in the same server please let me know.

 

Jorge

jotaandres Regular Visitor
Regular Visitor

Re: Power BI Gateways with data from two different sources

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.

"

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors