Forum Discussion
Failing to refresh Composite Model dataset - COM Error SSO?
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?
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.