Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I have the same issue refreshing the composite model whereby the Live dataset gives this error even though the gateway allows cloud refresh and the non-live data sources are configured. How can we get past this "Processing error: COM error: Microsoft.ASWL.Service, Single sign-on (SSO) credential is not provided which is required to execute the current request.. A connection could not be made to the data source with the Name of '{"protocol":"analysis-services","address":{"server":"powerbi://api.powerbi.com/v1.0/myorg/[workspace]","database":"[model]"},"authentication":null,"query":null}" jeroenterheerdt - please help as the composite model is unusable if it cannot be scheduled for refresh...
Microsoft Employeedid you go in and set the credentials?
Yes I had set the credentials. I have since recreated the composite model step by step and have found that the SSO error occurs after adding a calculated table into the model e.g. Account = DISTINCT(UNION( VALUES('Table1'[AccountCode]), VALUES('Table2'[Account]) ))
Is this an expected known limitation of composite models?
- jeroenterheerdt
from the docs/blog:"
- Some queries may return wrong results when there is a relationship between calculated tables and table(s) in a remote source. Creating calculated tables over a remote dataset is not supported although it is not currently blocked in the interface."
Thanks Jeroen, I guess this must be the cause of the error - although the message referring to SSO etc is not very helpful 😉