Thanks for sharing. The extreme lack of response to tickets and lack of any public messaging about the problem is a huge concern.
This appears to be fixed for us, since ~11:00 p.m. last night (Pacific). We've had 9 consecutive successful (hourly) refreshes since then.
Our dataset is in Premium capacity and its data source is Redshift. But our situation might be a bit different, in that our dataset is in Import mode, not Direct Query.
This seems to be fixed for us, too. However no one from Microsoft ever told us that it was fixed or told us to try again. Thanks to others here reporting success, I manually refreshed datasets and we re-embedded our Direct Query report and it is working as of right now. I hope others have success, too.
We ran into this issue again about an hour ago. Appears to be working now but we're skeptical that this is really fixed.
Can we please get some sort of response from @ms on this? If it's still in progress, let us know and we can at least set expectations with our users.