Forum Discussion

Vegard1985's avatar
Vegard1985
Helper I
5 years ago

Failing to refresh Composite Model dataset - COM Error SSO?

Hi,   I have an issue refreshing a dataset, would be great if anyone could point me in a direction as I'm out of ideas. I'll try to give a complete description.   Scenario: - A dataset in works...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi, Vegard1985 

By my research, I'm afraid that I have no ideas for your issue as I cannot reproduce it.

May be this artile will be helpful with you.

Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Vegard1985's avatar
    Vegard1985
    Helper I
    5 years ago

    Hi Yalan, Thanks for trying!

    In the topic you linked, there's talk of this still maturing, that calculate table is not working and will make the refresh break. Do you know if this still is true, I've failed to find that information elsewhere. I haven't purposely used calculatetable function. As mentioned I have two tables created by DAX in the model, could this be the culprit?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      We are having this issue as well - I would hope it's a bug that will get resolved.

       

      Based on my testing, I similarly found that the refresh fails when new calculated columns or tables are created.  This leads to RLS issues, as I can't create a table that can be used in Roles.  For example, even UserData = OriginalData breaks the online refresh, so I can't impose a UserData[Email] = USERPRINCIPALNAME() in RLS.