Hey Jessica,
This is an interesting problem and you're not alone in wanting to do something like this. The tricky bit is that Confluence doesn't act as an identity provider (this is where Atlassian Access/Okta/Azure SSO come in) so there's no clean solution to hand a Confluence user to another system.
In the past, I've seen people use an iFrame to embed the content from their BI system and use an embedded username/password in the iFrame. Depending on your BI solution, this might violate your user agreement. It's also not particularly secure, as the most adept among your users could intercept the "shared" username/password.
Given the pieces you laid out, there doesn't seem to be a great solution. If possible, I'd try to take screenshots or copy any images you need from the BI tool and paste them directly into the page on Confluence. The downsides of this are that you don't get any interactivity with charts/filtering you might want to do, and these screenshots would need to be updated regularly. Alternatively, you can see if there's a way in your BI tool to embed particular charts without authentication (public access). The HTML macro for Confluence add-on for Cloud can help with embedding some of this content if you haven't already checked that add-on out.
Cheers,
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.