I believe you can somehow circumvent security by using the fast combine option.
Not 100% sure, it's also new for me 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP