I have published a report to a workspace in Power BI, and have shared the content as an app with several end users. For some reason, the below message appears when the end users try to access the content within the app:
None of the following worked in trying to resolve this issue:
-opening the report file in Power BI Desktop, clearing the cache and republishing to PBI.com
-creating a new workspace, republishing the file to that workspace, then sharing that content as an app
I have created other reports and shared them as apps with the same end users in the organisation, and these apps have not had any issues. All users have Pro licenses, and I have never needed to manage the permissions of the specific datasets published to each workspace. When I look at manage permissions, all users have App, Reshare, Build permission.
When I encountered this issue before, I was able to fix it by creating a new blank Power BI Desktop file, copying across all of my queries from the existing file, rebuilding the data model and adding back all the visuals, then republishing the file.
As a temporary fix (and to avoid re-creating the Power BI file again), this time I have added all the users that I originally shared the app with as Admins on the underlying workspace. They are now able to see the app content, but as soon as I take the admin permission away, the same issue comes back.
Adding end users as Admins on the workspace is NOT an ideal solution. This appears to be a random problem and I would appreciate step-by-step guidance on how to resolve it (and prevent it from happening again in the future).