cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

Scheduled Refresh Error - Cannot connect to the mashup data source.

Hi all,

 

Im realy need your help, I have that error for 2 weeks, microsoft support dont give me any way to resolve the issue, after tring with them few basic things like publish the model again they asked me some logs and tell me it will go to product team.

Im relly need thats upadtes so maybe someone here had the same issue.

 

The spacific data set can be refresh from the desktop but i got an error when tring to refresh from the service :

 

Cannot connect to the mashup data source. See error details for more information.Hide details
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 6a57ba7a-354f-80df-a9a8-b124cc11e2e2
Request ID: 9fa979ef-a37e-65a7-7a4c-a31e95cb5d1f

 

The data sources that this dataset uses are being used in other datasets and everything is fine with them, so its not a problem on my servers with port or something.

Does anyone know some way to resolve it?

 

Thanks for your help!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

I solved the issue

I cant explain why i got that error only with that data set but when I add the gateway IP to the servers whitelist the issue has been resolved.

 

thanks all for your help

View solution in original post

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

Hi @Drors

Do you use mixed data sources here?

After researching, I find some similar issues sloved and hope it can give you some ideas.

Enterprise gateway "cannot connect to the mashup data source"

Cannot connect to the mashup data source

 

Best regards

Maggie

 

 

Highlighted
Resolver III
Resolver III

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

if mixed data source means several DBs on diffrent servers and also APIs connection so yes..

I have tried all the solutions in these 2 posts but nothing help

 

Thanks

Highlighted
Community Support
Community Support

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

Hi @Drors

"several DBs on diffrent servers"

Do you have gateway on these different servers to connect to DBs?

 

Regards

Maggie

Highlighted
Resolver III
Resolver III

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

I solved the issue

I cant explain why i got that error only with that data set but when I add the gateway IP to the servers whitelist the issue has been resolved.

 

thanks all for your help

View solution in original post

Highlighted
Frequent Visitor

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

Drors,

 

I'm experiencing the same issue. How do you add the gateway IP to the servers whitelist?

Highlighted
Frequent Visitor

Re: Scheduled Refresh Error - Cannot connect to the mashup data source.

Drors,

 

I'm experiencing the same issue. How do you add the gateway IP to the servers whitelist? Can you tell me the steps please?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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
Top Kudoed Authors