Forum Discussion
DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)
I fixed it, it was actualy the query itself causeing it to time out. I re-ajusted the query and no more issues.
Hi eTribble,
Excuse me, could you please explain a bit more about the error I'm seeing in Power BI? I would like to better understand the queries you're using in order to solve the problem more effectively. Could you please provide me with more details or explanations about the specific queries you're using?
I've been having the same problem since January and I've been doing a manual refresh every day to avoid this problem. Do you change only the query or also the datasets and DAX formulas?
Regards.
Its hard to explain without giving away to much buisness info:
But the simple version is the MYSQL query I was useing was causing the MySQL connection to time-out and close becuause it was going over the 60sec limit.
Like if you are using MySQL workbench and run a complex query and it never loads because it fails, this is that.
So my query originally worked because the date range was small, it was only a span of a few months, but as time went on it was growing and growing and when this error occured it was trying to do an complex query with a large date range (multiple years).
So I had to break it up into 2 queries, 1 for the first year, and ran it once, and then set it to not auto refreash ( the data in it shouldnt change)
Then the newest data is on a new query and runs fine. And when it gets near the end of the year ill probably archieve this years data and start the query from 2023-12-01 and go from there.
Thank you very much, this is really great.