Hey all. I'm new to power bi, and I'm struggling to find an answer to this question. We routinely build power bi apps for customers as part of our business. Up to this point, those have been built on the CUSTOMER's Azure account. This is a hassle because it requires the customer to manage and setup a number of things (or we do it for them). We would like to centralize this on our own instance so the data and apps reside on our tenant under our control. Normally, that would be pretty easy. We would build a custom app that does oauth or forms auth, and then present whatever we wanted based on some back end permissions configuration.
However, that doesn't work for most of our customers that interact with PowerBI via Excel. These customers want to/have to login using their existing O365 credentials which are to tied THEIR tenants and not ours. Is there some magical way that would allow a customer to use their own login information to access power bi apps/data on our instance? I have looked into SAML SSO and even joining AD forests (which is a terrible hassle), but I don't believe any of those would actually work. I can't see a way to get "in front" of the Excel functionality. If anything isn't clear, please let me know, and I can clarify. Thank you.
