We have a workspace which contains only a report. The report utilizes a dataset in a separate workspace. Access to the report is controlled by an App on the workspace. We have granted read-only access to end users in the dataset.
I thought I could embed the report in a webpage, and limit access using the App. However, when the end user authenticates, they are prompted to request access. I am guessing this is because they have access to the App, but not to the report directly and the security from the App is not inherited by the report.
Curiously, if a user follows a link to the report in the PowerBI service they can view the report without issues. However, we'd really like to distribute the report using the webpage.
Is it possible to do this? How can I prevent legitimate users from being prompted to request access?
