Forum Discussion
[REFRESHING] Error with dataset refreshing
Hello everyone,
I recently made a change in my request set in some dashboard I had. I created a duplicate of one request to make some calculus to it. Once this was done on my desktop, I uploaded it to my app.powerBI, here is the problem, It seems that the dataset cannot be refreshed through my gateway, even if it's rereshing in my desktop. I got the following JSON Error text:
{"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":"mysql04.zs.daevel.fr:3306;mykadee"}},{"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}}}
The error message precise that the concerned table is the original table I made the duplicate from.
I think the amount of requests I make to the database through my gateway might be too big.
Maybe someone has a clue of what's realy happening ?
Thanks for your attention.
2 Replies
- Greg_DecklerCommunity Champion
Very difficult to troubleshoot. 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". - v-deddai1-msftCommunity Support
Hi davidvincentret ,
Would you please try to uninstall the gateway and re-install the latest version of the gateway, update the setting of Mashup engine by this link?
In addition, if both personal gateway and enterprise gateway running on the same machine at the same time, there seems to be a conflict. It is recommended to uninstall the one which is not currently using.
If it still doesn't work, please create a support ticket with Activity ID and Request ID provided.
Since you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Dedmon Dai