Daily Scheduled Refresh failure

[ansonKSI]

I have been experiencing issues during the scheduled daily refresh, which started around one month ago. I am a pro licensed user and here is the error message. my dataset has a little over 10M rows of sales transaction data starting from 2018 -01-01 to YTD, and the PBI file is 233MB. I tried the incremental refresh feature but it hasn't been working either.  The incremental refresh is set to import prior day's transactional data. 

Please help!!

Activity ID: e6908b38-c8e5-4eaf-b4b5-bd4cec33a9ad
Request ID: b06d3d19-640b-df16-c011-5cb5d2857a65
Correlation ID: dfa4f13b-5d01-810e-7c27-680171f5b1fb
Time: Wed Nov 17 2021 10:19:13 GMT-0500 (Eastern Standard Time)
Service version: 13.0.17137.52
Client version: 2111.2.08565-train
Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net/

[v-jayw-msft]

Hi @ansonKSI ,

You could also take a look at this topic.

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

Try changing the Privacy Level on Power BI Service.

Best Regards,

Jay

[GilbertQ]

Hi @ansonKSI 

Are there any more error details you can provide?

If not I would suggest contacting support: https://powerbi.microsoft.com/en-us/support/pro/

[ansonKSI]

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[],"exceptionCulprit":1}}}
Cluster URI: WABI-US-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: a33654e4-7a48-498b-9b6f-93cc27827b0f
Request ID: 0bf14add-9308-4cae-bed6-3c7b47e8252b
Time: 2021-11-17 13:16:31Z

[GilbertQ]

Hi @ansonKSI 

I was having a similar issue recently.

What I did was to install the latest version of the Gateway software. 

I then also restarted the Gateway server and that resolved the error.

[ansonKSI]

Thank you. Let me give it a try and will keep you posted.