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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Thurmus
Frequent Visitor

On Premise Data Gateway Dataset Refresh Error

I am having an issue with two reports that use different tables/queries from the same database on the same SQL server. I do not have the same issue with my other SQL Server. When I try and refresh the data in the published report I get the following error message:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: PatchCategory.

 

I previously got this message but the table was Status. I renamed the PBI query Status to Status2. I then duplicated another query, copied the SQL query from Status2 and pasted it in to the new Query1. I then renamed Query1 to Status. I then saved and published the report. When I tried to refresh the dataset it gave me the error above. I checked the report and when I look at Data Sources there is only the one.

 

Can anyone provide more information on why this may be happening or why the fix I tried worked? I have a of queries in the report and changing them like I did for status means redoing all of my visualisations, measures and calculated columns which I am trying to avoid.

 

I have looked through the forums and as per suggestions elsewhere, rebooted the gateway server, removed the gateway all together and created a new one and checked the permissions are identical for both SQL servers as well.

 

Thanks in advance.

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @Thurmus ,

 

Check the similar thread below:

https://community.powerbi.com/t5/Service/DM-GWPipeline-Gateway-MashupDataAccessError/td-p/1047721

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

amitchandak
Super User
Super User

@Thurmus , refer if these can help

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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