Multiple data sources

[Maffimau]

Hi all, I'm new in PowerBi and I tried to connect more yhan une source in the same time (XLSX file and SQL serve source) to do some calculation and have result in one dashboard.

In Desktop app all is ok and I'm able to refresh all data from different sources, but when I try to public my reprot on internet I have an error "the gateway (Power BI – personal) is è offline. Check the Gatway if is Online." so I can't do nothig, view data, refresh data, etc... If I use only XLSX or SQL source alone all is ok, but togheter noway.

I check in the gatway setting and the XLSX file is online and connected, also for the SQL source is online and connected.

Someone can help my?

Thank you very much

[tringuyenminh92]

Hi @Maffimau,

Have you tried with On-premise gateway (enterprise gateway) instead of personal gateway?

[Maffimau]

Hi, I alredy installed the One-premise gateway. Probably the problem is that the XLSX file is in one server with one gateway, and SQL data are in another server with another gateway? (all two are One-premise gateway).

[Anonymous · Accepted solution]

Hi @Maffimau,

All the data sources for a dataset have to belong to the same gateway in order for you to be able to refresh. Please add Excel data source and SQL Server data source under a same on-premises gateway or user personal gateway to refresh your dataset.

Thanks,
Lydia Zhang

[Maffimau]

Solved, thank you very much

[Maffimau]

Hi, I alredy installed the One-premise gateway. Probably the problem is that the XLSX file is in one server with one gateway, and SQL data are in another server with another gateway? (all two are One-premise gateway).