Cannot connect to the mashup data source

Question

Hi all,&nbsp;Really stuck!&nbsp;I'm having problems refreshing a SQL server datasource from Power BI service. I can refresh the data in desktop, and can configure the datasource in the enterprise gateway, but I cannot refresh or schedule refresh in Power BI service.&nbsp;I am getting the following error message:&nbsp;Last refresh failed: Fri Oct 12 2018 20:08:20 GMT+0100 (British Summer Time) Cannot connect to the mashup data source. See error details for more information.Hide detailsCluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.netActivity ID: c2541578-23ce-46e4-a671-087c35989d8eRequest ID: edb7c772-3d3d-89cd-c651-f834a2d4cf04Time: 2018-10-12 19:08:20Z&nbsp;Has anyone else come across this? I am able to connect refresh from other SQL databases but just having a problem with this one.&nbsp;Regards&nbsp;Mike

v-danhe-msft · Answer

Hi&nbsp;Anonymous,
Could you have assigned the data base when you are getting data from SQL server? I have found the same issue that you could have a view:
https://community.powerbi.com/t5/Service/Cannot-connect-to-the-mashup-data-source/td-p/346879
&nbsp;
Regards,
Daniel He

anonymous · Answer

Hi Daniel&nbsp;The database is already assigned in desktop.&nbsp;Regards&nbsp;Mike

anonymous · Answer

Still getting this error message. Can anyone help? Thanks

tommartens · Answer

Hey,
&nbsp;
without further knowledge, it will become quite difficult to provide some additional&nbsp;hints.
&nbsp;
But as you have already stated, other on-premises SQL Server data sources can be refreshed from within the Power BI Service using the same on-premises data gateway machine.
&nbsp;
So the question is what sets this database / SQL Server apart from the other data sources:

can you ping the database machine form the gateway machine
maybe&nbsp;the authentication mode for this data source&nbsp;is Kerberos whereas the gateway machine / the service account is not prepared for this

Have you had a first glimpse at the log files of the gateway.
&nbsp;
Debugging this can become quite lengthy.
&nbsp;
Regards,
Tom

anonymous · Answer

Hi Tom,&nbsp;Thanks. Will check pinging the machine and gateway logs.&nbsp;The connection works in the service when using direct query, just not when the data is imported.&nbsp;Any idea why this would be?&nbsp;Regards&nbsp;Mike

Forum Discussion

Cannot connect to the mashup data source

5 Replies

Related content

Dataflow Gen2 Mashup Error

Dataflow Gen 2 Mashup Error

Unsolveable Mashup Data Access Error

Dataflow Gen2 Mashup Error

Power BI Desktop – Installation Issue | Mashup Engine Error