Error while refreshing through gateway

[mazinzr]

Hi 
I'm getting this error massage everytime I refresh through the gateway.
Refreshing using PBI Desktop is working fine...

We noticed that these errors are on tables that contain a 'Merged Queries' as a step on the APPLIED STEPS on PBI, 
and when we removed these steps it started to complete the refresh through the gateway. 

Any idea on what can be done to solve it? 

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Fatal error encountered during data read."}},{"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","detail":{"type":1,"value":"server"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during data read."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Daily Business Monitoring.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: 00000000-0000-0000-0000-000000000000
Request ID: 9df8fd52-4f93-4f34-9cb2-b75f10d4ed7c
Time: 2022-07-05 04:50:42Z

[RachelGomez1619]

The 502 Bad Gateway Error can definitely be irritating. Confused about how to tackle this awkward situation? Don’t worry. This step by step guide will help you fix this error in no time.

1.Reload the page:

Press CTRL-R or F5 on your keyboard to reload the page. You can also right click with the mouse and select refresh or reload. This can be the easiest step to solve this error.

2.Reload the Browser:

Try closing all the tabs and closing the browser. Then restart the browser and start the new session. Now, visit the page again. The error may have caused by the use of your browser. A restart might solve the problem.

3.Clear Browser Cache

A Browser stores important information in the cache. Sometimes this information becomes outdated and corrupt. This might cause the 502 Bad Gateway Error. Clearing the browser cache will resolve the problem. Here is how you can clear the browser cache for all the latest browsers .

4.Clear Browser Cookies:

Cookies are stored to retain certain data that is required to access a webpage. As is the case with browser cache, cookies can be outdated. It is best to try clearing cookies if clearing cache does not solve the problem. You can also delete specific cookies for each site instead of deleting all of them. It is better to delete all the cookies but you can try deleting specific cookies if that solves the problem.

Regards,

Rachel Gomez

[FarhanAhmed]

Check out below solution from similar post

Solved: New ErrorCode=-2147467259 - Microsoft Power BI Community

"

It was to do with the permissions. Clearing all data source permissions (File-->Options and Settings --> Data Source Settings --> clear each data source permission). 

Doing this for both local and global permissions and reentering credentials when refreshing fixed the issue"

[mazinzr]

Hi @FarhanAhmed  
Thank you but unfortunatlly did not solve the issue.
my problem is not refreshing through PBI desktop, it is only when trying to refresh with the gateway (using API/ refresh button on the web ).