Refresh Error

[ybarsabal]

My company is getting this error for all dataset refreshes that use our On-premises data gateway. We've checked on the gateway status and things look correct. The error is thrown within 1-2 seconds. The admins say they've tried all the troubleshooting suggestions from the internet, no luck. I've tried simplifying datasets to 1 simple table, no luck. Weirdly, a dataset that uses direct query through the gateway does work, so we're stumped.

Data source error:	{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Grades.
Cluster URI:	WABI-US-NORTH-CENTRAL-D-PRIMARY-redirect.analysis.windows.net
Activity ID:	6ee5809c-00f2-48c5-971b-9010eb009272
Request ID:	84e26147-300f-4717-9d4b-928827338c71
Time:	2020-05-12 18:39:09Z

[ybarsabal · Accepted solution]

Solution: There was a SQL certificate that was not selected. Once that selection was toggled, refreshes began working properly.

This has happened once before. For some unknown reason, in the setting below where there is normally a certificate selected, the selection somehow became unselected. All our admin did was to reselect it and apply. I think he also restarted the SQL server.

[Anonymous]

Hi @ybarsabal ,

Thanks a lot for sharing your solution. It will also help the others if they face the same problem with you. 

Best Regards

Rena

[Anonymous]

Hi @ybarsabal ,

Whether it can refresh successfully?

Best Regards

Rena

[Anonymous]

Hi @ybarsabal ,

Could you please provide the following information in order to make troubleshooting?

1. What's the data source of the related dataset? Are they from multiple data sources? Which connection mode is using?

2. Whether all of the involved data source itself can connect successfully?

3. Whether all of the involved data sources be configured into gateway? 

4. Whether the version of gateway is latest one? If no, you can download it from this link and update it to latest one.

5.  Any firewall block it?

In addition, you can review the following documentations for troubleshooting in your side:

3 tips to avoid a missing gateway with Power BI

4 Troubleshooting connectivity tips with the gateway

Troubleshooting Power BI dataset refresh failures

Best Regards

Rena

[Greg_Deckler]

I would say make sure you are on the latest copy of the gateway and then You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".