Enterprise gateway "cannot connect to the mashup data source"

Thanks for reporting. We'll take a look.
Could you send your Gateway logs to [email protected]. You can find your logs here: 

 C:\Users\PbiEGwService\Appdata\Local\Microsoft\Power BI Enterprise 

Hello,

I´m also having the same issue. 

I´m trying to connect to a parvasive database through an ODBC (32 bits). I have tested that ODBC and it is working fine, but it is being impossible to use it in a new power bi data source. 

I have tried to add an SQL Server data source, and there is not problem in this case. 

Hope someone help me. 

Thanks in advance.

Hi everyone!

I'm facing a similar problem.

I'm conected with an SAP Bussiness Warehouse Server, in which the data is stored in Cubes (MDX).

After publishing my report, I had to stablish an On-Premisse Gateway, which after some headaches was conected

Now, when I try to mix the dimensions and measures from the cube, it gives me the same message: "cannot connect to the mashup data source".

This is a part of the message:

Having this issue with an Enterprise Gateway. I removed a Personal Gateway (that had worked fine). The data sources in the Enterprise Gateway all connect without error yet the Datasets won't manually refresh or schedule refresh. Reports don't refresh either. I have to refresh everything from Desktop manually.

It's a definite show-stopper.

Any help from the technical team on this would much appreciated.

Hi guys!
I've found the solution for me.
I noticed that this problem appeared after adding the new server in our domain.
So I decided to use "gpupdate /force" from the cmd on the machine where DataGateway installed.
After group policy were updated the problem disappeared.

I am also getting the same error message.

My data sources: Dynamics 365, two Excel spreadsheets (not tables) in Sharepoint/One Drive for Business, and a web page.

As I understand it, it's only the web page that has me needing the gateway at all. In any case, I can set up all my connections in the gateway, and it seems satisfied with the credentials I provide (anonymous for the web page, OAuth for the others). But when it comes time for the schedule refresh, the gateway spins for a long time and then returns this error.

I have the on-premises gateway installed, and I've never had any other gateway installed on this machine (it's a virtual machine in AWS, set up specifically for this purpose).

Based on an earlier suggestion in this thread, I looked at my gateway logs. They're just line after line of "Pool cleaner connections removed," whatever that means.

same problem here.

updated the gateway to the latest i.e Sep 2018; refreshed the report in Desktop and re-published it on the Service, still getting the same error message.

referred to the log files on the server and found the follwoing

UserName: MyAdminAccount
MachineName: ServerName


EAD7B167 [DM.EnterpriseGateway] Starting On-premises data gateway service
[DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
9D1FD689 [DM.GatewayServiceHost] Starting direct query pool if necessary.
[DataMovement.PipeLine.MashupCommon] Mashup Container Pool DirectQueryPool created.
 [DM.GatewayServiceHost] Direct query pool created True.
[DM.GatewayServiceHost] Starting test connection pool if necessary.
[DataMovement.PipeLine.MashupCommon] Mashup Container Pool TestConnectionPool created.
[DM.GatewayServiceHost] Test connection pool created True.
[DataMovement.PipeLine.MashupCommon] Mashup Test Connection Settings - TestConnectionTimeout: 00:00:50.
[DataMovement.PipeLine.MashupCommon] Mashup Engine Container Settings - ContainerMaxCount: 6. ContainerMaxWorkingSet: 256MB. ContainerTimeToLive: 
[DM.GatewayServiceHost] MashupCustomConnectors = True
[DataMovement.PipeLine.MashupCommon] SetMashupConnectorsProviders: instantiate memory provider with extensions developed for gateway
[DataMovement.PipeLine.MashupCommon] Mashup extension file (R, powerbiextensions.r.mez) exists. Start loading.
[DataMovement.PipeLine.MashupCommon] Mashup extension file (Python, powerbiextensions.python.mez) exists. Start loading.
[DataMovement.PipeLine.MashupCommon] SetMashupConnectorsProviders: instantiate PowerBIExtensions assembly
[DataMovement.PipeLine.MashupCommon] SetMashupConnectorsProviders: instantiate filesystem provider at C:\Users\MyAdminAccount\Documents\Power BI Desktop\Custom Connectors, expanded: C:\Users\MyAdminAccount\Documents\Power BI Desktop\Custom Connectors
[DataMovement.PipeLine.MashupCommon] MashupLibraryProvider filesystem provider did not start. Reason: The directory name C:\Users\MyAdminAccount\Documents\Power BI Desktop\Custom Connectors is invalid.

I am not using any custom connector; so why it is set to True in Mashup engine?

I ended up un-installing and then re-installing the latest version of the gateway to overcome the issue.

PROBLEM

My day started with error during refresh via gateway:

{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"An error happened while reading data from the provider: 'Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath" ...

I tried all recomendations above, nothing helped in the begining.

STEPS I DID TO SOLVE

1. Refresh stopped working even from power bi desktop. Got error  
   1. I renewed to Power bi desktop [Version: 2.79.5768.721 64-bit (2020 m. kovas)]    (didn't help)
   2. Added OldGuids=true in  
      • Source = MySQL.Database("xxxxx", "dwhdb", [ReturnSingleDatabase=true,OldGuids=true])   (this solved me refresh in power bi desktop, but refresh via gateway was still failing)
2. At this moment Refresh via gateway didn't complain about Guid, the error was 
   • {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Products Data

Finally I remembere doing mysql 8 config changes for ETL tools.

What caused issue for me was character-set-client-handshake=FALSE. I commented it out and it started working again.

I also undone step removed OldGuids=true, which was no longer necessary. And all started working again.

CONCLUSION

For me it was caused by MySQL 8 character set configuration. So if you have issue - you may want to revisit your configs of the data source.

I am facing this issue right now.  I cannot create a new DataFlow then using OData. When I enter in the URL to connect to, which is an Azure DevOps URL, and I use the Organiztion Account as the Authentication Kind, when I click Sign In it just hangs on the MashupEditor page with a spinning icon. I have cleared browser cache and check the status of my data source and it shows as Online. This is happening to 3 other co-workers too. So it's not just my account. I can get to the Azure DevOps URL I am using in the OData statement in a different tab of Chrome but I cannot get the Mashup editor to respond.

What are some suggestions to resovle this?