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

Multiple data sources

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Multiple data sources

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

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

View solution in original post

5 REPLIES 5
tringuyenminh92 New Contributor
New Contributor

Re: Multiple data sources

Hi @Maffimau,

 

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

Maffimau Frequent Visitor
Frequent Visitor

Re: Multiple data sources

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).

 

Maffimau Frequent Visitor
Frequent Visitor

Re: Multiple data sources

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).

Moderator v-yuezhe-msft
Moderator

Re: Multiple data sources

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

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

View solution in original post

Maffimau Frequent Visitor
Frequent Visitor

Re: Multiple data sources

Solved, thank you very much

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 60 members 1,150 guests
Please welcome our newest community members: