Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KilianG
Frequent Visitor

DM_GWPipeline_Gateway_MashupDataAccessError after deploying to test in pipeline

We have the following situation:

  • dashbords in a deployment pipeline.
  • all workspaces / dashboards /datasets in this pipeline have the same admins /users and settings
  • there are no staging variables
  • all datasets use the same on premise gateway.
  • The gateway admins and datasource users are the same as those for the workspaces / datasets

On development stage everything is working fine, but after deployment to test stage the refresh fails with an DM_GWPipeline_Gateway_MashupDataAccessError
All dataset settings are the same here, too- only in test there is a scheduled refresh. But even if deactivated the error stll occurs.
I tried most of the "solutions" of the other posts(restarting the gateway, setting https-mode off, set the scope of the data sources to the same value, etc.), but none of them helped. Some are no option - e.g. deleting the dashboard from the workspace, since it's embedded in several websites and with deleting/recreating the reportid would change and so cause trouble (and effort) on other (customers!) side.
As eyerything is set up identically, i don't believe it to be a problem of the gateway.

Is anybody able to help?

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

On each gateway cluster member validate that you can reach each of the databases.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

On each gateway cluster member validate that you can reach each of the databases.

Although this was the solution, i do no understand the concept behind it:
If i have to give each user of the cluster acces to each datasource anyway - why is there an option, to set access for each source?
This would mean, that if i want to have users with different Data access, i have to create new gateway clusters?

No, but you will have to create separate connections, even if it is the same exact data source.

 

Don't forget - gateway cluster members are zombies - they have no idea what's happening around them. All they know is to ask the gateway service if there are jobs available.  They need to have the right plumbing (network access and drivers)  but don't need to know anything about credentials. Credentials are supplied by the service as part of the job ticket.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors