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.
Any known workarounds? I spent weeks developing a data model only to find out that now it's impossible to refresh via the service. That's a no go for our users. Is there really no way to add transformation steps to a shared dataset?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.