Data Gateway for Data Source containing SQL Server and Excel file

[ybarsabal]

I created a data source using SQL Server merged with an Excel file. Power BI Service says I need a data gateway for this. We already have a data gateway set up for the SQL Server, but I'm guessing it's looking for a separate data gateway, specifically for this merged data source? What's going on here?

[v-piga-msft]

Hi @ybarsabal ,

What is your excel file? online or on-premises?

If your excel file is online, you don't need to add it to data gateway.

If your excel file is on- premises, you need to add it to the data gateway.

You could add the two data source in the same gateway.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[ybarsabal · Accepted solution]

Ok, looks like this might be solved with a setting on the gateway you already set up. I'll get my admin to enable this and report back when I have an update.

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

1. Manage gateways.
2. Select the gateway you want to configure.
3. Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply.

[ybarsabal]

I first tried using an on-prem Excel file, but after I wrote my original post I switched out the Excel file for a OneDrive file (using Web URL) and got a similar result. The SQL Server has a gateway which works if it's the only source. I also tried the OneDrive Web URL which also refreshes when it's the only source. Are you saying it's possible to add this specific merged data source in the gateway? I don't  actually manage the gateways, so I don't know all the options.