cancel
Showing results for 
Search instead for 
Did you mean: 

Gateway Refreshes failing

Hello everyone!

 

I'm having an issue with the gateway refreshing our dataset. I have connected it and sometimes it works and sometimes it doesn't.

When it does fail i get an error like this:

Unable to connect to the data source undefined.

Underlying error code: -2147467259 Table: {our table}

Underlying error message: MySQL: Fatal error encountered during data read.

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259

 

As I said, this does not happen all the time but it's annoying me. It's always one of two tables out of maybe 10 in total that gives me this error. The data source and table columns doesn't change one bit, of course there is more data being added to them all the time, but that shouldn't be a problem, right?

 

After every error i go into my .pbix file and check the tables, but there are no errors or anything.

 

Does anyone have any ideas?

 

Thanks!

Status: New
Comments
Community Support Team
Visitor

Thank you, I had timeout set to one hour on most of my tables but it seems I have missed a few. Will try to add it to the new tables.