cancel
Showing results for 
Search instead for 
Did you mean: 

Allow Power BI Dataset Direct Query (composite Model) on power bi service to be able to refresh

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. 

Status: New
Comments
groovijewelz
New Member

Exact same issue - or at least let us set up an MS flow to republish the dataset 😂

JMarkillie23
Regular Visitor

Also facing same issue when creating calculated tables on a PBI dataset. Any help would be appreciated!

Nielf
Helper I

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.