Using Multiple Schematic Models

[Anon29]

Hi everyone, I having a problem where users can't see the report visuals in a specific reports.

The report is setup with like this. I have uploaded two datasets into our premium power bi workspace. The first dataset is the main dataset which is connected to a second dataset via direct query. 

The report is created using a live connection to the main dataset using tables that are from the main dataset and the second dataset. I have set it up this way because the second dataset takes longer to refresh and it refreshes at a different time of the day, and I don't want this dataset to affect all the other reports that do not rely on it. Users can't see the visuals of this report where the data is from both datasets. However those with higher workspace role privalage can. 

Users can see all the reports that are built just from the tables of the main dataset just fine. I don't want to give users higher workspace access than Viewer access, but I still want them to be able to view the report. Does anyone know what I can do?

[GilbertQ · Accepted solution]

Hi @Anon29 

When the dataset is refreshing that will not affect the reports. I would recommend simplifying it to having a single data set, which then allow you to easily achieve your requirements.

[Anon29]

Thanks for suggestion and it was what I was planning on doing at the very start. However I would like to keep the 2nd dataset seperate to the main dataset. The second dataset pulls data from a server and can often cause refresh problems for me. Only a couple of reports rely data from the 2nd dataset I'd like to isolate this dataset so that the main dataset can refresh successfully for all my other reports. Hope that makes sence.

[aj1973]

Hi @Anon29 

First of all End users shouldn't be added to workspaces even as Viewers only. End users should consume Reports and Dashboards in Apps where you can add them or add security groups to audiences.

To enable users to see data in visuals that are coming from Dataset 2 you will need to add them to the Manage permission of the dataset it self(Not the workspace). To do that go to the workspace where the Dataset is located and  

then

with Read permission

[Anon29]

Thanks Amine, I also gave that a try and that didn't work for me too. For the time being, I ended up just rebuilding both the datasets into one dataset as with Gilbert's suggestion.