CRM Online and Live Query

[roosterm]

We are looking to leverage PowerBI as a replacement to the OOB dashboards internal to CRM Online. Unfortunately, we can't provide dashboards or reports to our users with their security model. Each user has specific records they can access, however, we're unable to pass through their user credentials to pull the data they should be able to see. If we could refresh the report using their credentials, we would be able to provide powerful reporting to many areas of our business.