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

On-premise data gateway refresh fails when merging two tables from different web content sources

I created data model that uses few data sources frome online web content.

For example (Xml.Tables(Web.Contents("http://......./?year=2019")))

 

The model refreshes successfully from the desktop version.

 

After publishing the model, i m able to select on-premise data gateway to refresh the model

(gateway version 3000.0.144.3 October 2018 )

 

The problem appears when one of the tables uses two sources by merging them.

When i try to refresh the model i get an error message:

"Cannot connect to the mashup data source. .."

 

 

When the model is using the same sources withot merging them, all works fine.

 

 

Anyone have a feedback?

 

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: On-premise data gateway refresh fails when merging two tables from different web content sources

Hi @nellys

 

I would suggest to first make sure you are using the latest version of the On-Premise Data Gateway

https://powerbi.microsoft.com/en-us/gateway/

 

And then ensure that you have got the following configuration enabled on the Power BI Gateway in the Power BI Service

image.png





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

Proud to be a Super User!







Power BI Blog

Highlighted
Community Support
Community Support

Re: On-premise data gateway refresh fails when merging two tables from different web content sources

Hi @nellys,

 

Is there any advanced options in query editor?(e.g. append, merge, invoke custom function, reference another query) AFAIK, power bi service not support to refresh report who contains custom functions.

 

>>The problem appears when one of the tables uses two sources by merging them.

Maybe you can try to use two queries to get data from different datasources, then use create new query to combine these queries tables to one.

 

In addition, have you update your datasource credentials on service side?

 

BTW, cloudy data source not need to use gateway handle refresh, you can refer to GilbertQ's suggestion to turn on option to use a gateway to manage refresh operation.

 

Regards,

Xiaoxin Sheng

 

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Frequent Visitor

Re: On-premise data gateway refresh fails when merging two tables from different web content sources

@GilbertQ , Thank you for your reply.

 

The on-premise gateway version is from October, 2018.

And yes, the check box is selected.

Highlighted
Frequent Visitor

Re: On-premise data gateway refresh fails when merging two tables from different web content sources

@v-shex-msft, thank you four your suggestions,

1. I tried now to separate the problem, as you suggested:

I created two separate tables from two services - the the gataway refresh works exellent/

I created addition table, that merging (by merge command) two previous - fails with "Cannot connect to the mashup data source".

 

2. An option to use a gateway to manage refresh operation is turned on

 

 

 

 

Highlighted
Super User IV
Super User IV

Re: On-premise data gateway refresh fails when merging two tables from different web content sources

Hi there

What are the Privacy settings set to for the 2 table sources?




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors