Hello Everyone,
I created a report based off of a dataset in a different workspace (Workspace A), then uploaded it to a new workspace (Workspace B). The dataset did have changes made to it in the composite model, so I ended up with a local model as well that also got uploaded. I went to "Manage Permissions" on both datasets and ensured that my user had read access on both. The user was then added as a member of the Workspace B. I also added the user to the app created from Workspace B.
I started noticing that the visuals in the new report based on the dataset in Workspace A weren't rendering for that user. On a different user's account, the visuals worked perfectly. To test, I added the user to Workspace A as a viewer as well to see if that would help. The visuals still did not render. I then increased the membership level to "Member" for that user on Workspace A and Voila! The visuals rendered and worked perfectly.
I'm not so sure I want that user as a member in Workspace A though as it contains reports from other departments in my company. I also wanted to make them viewers because they are new to Power BI and I didn't want them to accidentally delete or change anything. I thought, with "Manage Permissions", they wouldn't have to be on the workspace of the dataset (it worked with shared Power BI datasets; the users didn't have to be associated with the actual workspace of the dataset). I was moving to composite models so I wouldn't have to repeat my models and would only have to load the data in them once as opposed to in every report I create. If there is no real workaround for this, my plan is to make a common workspace for datasets I use often so that I have no qualms with the user being a member of that workspace. Has anyone else experienced this? If so, what did you do to workaround this issue, or is there a solution I am missing?
