Does the enterprise gateway support SQL server and Excel data sources in the same Power BI file at t

[Anonymous]

Does the enterprise gateway support SQL server and Excel data sources in the same Power BI file at the same time? 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

When a pbix file contains two kinds of data sources, you could click "refresh" button on Power BI Desktop main menu.

If you want a schedule refresh, please publish the pbix file to Power BI Service and configure schedule refresh for two data sources.

Steps:

1.

install on-premise gateway:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

1.1 if sql and excel sources are in the same server, install a on-premise gateway on the same server.

1.2 if they are in two different servers, please install two gateway in two servers,

      sign in with the same power bi account for two gateways.

2.

on Power VI Service, go to Gateway setting,

2.1 add SQL SERVER as a data source under the gateway and give the correct credential.

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

2.2 add excel file under the gateway.

https://docs.microsoft.com/en-us/power-bi/refresh-excel-file-local-drive

3.

go the setting of that dataset, configure schedule refresh settings.

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@Anonymous ,

Refer below screen shot. First is SQL Server connection and second is Excel file on same Server where my Gateway is installed.

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[Anonymous]

Can I copy anywhere in the same server?

[Tahreem24]

@Anonymous ,

Yeah, it support both the SQL Server connection and Excel file. But make sure your Excel file is located exactly where your Gateway is installed.

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[Anonymous]

How the data from excel file will refresh?  

[Tahreem24]

@Anonymous , In my case refresh is not required cause it kind of mapping sheet.

you can refer below link for more deets:

https://www.skylinetechnologies.com/Blog/Skyline-Blog/September_2016/RefreshingPowerBIReports

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!