currently this works fine when refreshing over power bi desktop but its a limitation on the power bi service that give a SSO authentication error and doesnt allow to refresh (this its actually a noted limitation on power bi dataset direct query.
Exact same issue - or at least let us set up an MS flow to republish the dataset 😂
Also facing same issue when creating calculated tables on a PBI dataset. Any help would be appreciated!
Yeah this really came as a surprise.
Everything works fine i Desktop - then you find out, it doesn't work in Service.
I also tried to see if it was possible to refresh the dataset using Power Automate, but that doesn't work as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.