Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
tameezmoosa's avatar
tameezmoosa
Frequent Visitor
5 years ago

Hi

I have tried this and it does not work as it says i have a credential issue when refreshing on service

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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...

    • jeroenterheerdt's avatar
      jeroenterheerdt
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      did you go in and set the credentials?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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?