cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
till_obos
Regular Visitor

Issue with sharing older dataset with "Viewer" role users. > Unable to load Model.

So here is an interesting one:

I have a dataset that works just fine and sharing also works with all users as long as they are either from the role admin, contributor or member. Users with the viewer role trying to access any report built on top of the dataset get this error:

till_obos_0-1631869515484.png


Everyone involved has a PRO license, either bought or in a trial. 

So while doing some research I saw that RLS might be an issue here so I tried to create a new datset using the same sources and to my surprise that actually works flawlessly.

Then I tried to strip every data source from my original dataset in Power BI Desktop until I was only left with no connections to any external source and basically only some test data entered directly in PowerBI. Like this:

till_obos_1-1631870258849.png

till_obos_2-1631870318409.png

Uploading this dataset and trying out having users with the viewer role access it, still failed.

So I am left with 3 options:

1. Recreate the entire dataset.
(Is there a good way to import every query, all settings and all relationships into a new file somehow?)

2. Someone can help me find out why this error exists in the first place, so that I can fix my old dataset or change settings accordingly.
Obviously I would prefer this router and any help will be very much appreciated.

3. Give everyone contributor+ access to the workspace, which would be very much against company policies, so I would like to avoid that route.

Thanks for the help.

Best Regards,
Till

1 ACCEPTED SOLUTION
till_obos
Regular Visitor

I was able to fix it by recreating the entire dataset from scratch copying every query, recreating every relationship, recreating all DAX tables, columns and measures and copy and pasting all report pages on the main dataset report.

This took a very long time as my dataset is quite very large (~100MB) and PBI Desktop tends to act very sluggishly when creating new columns or hiding columns, etc.

I hope now one else has to go through this, but if you don't have a choice, this can fix it.

View solution in original post

4 REPLIES 4
till_obos
Regular Visitor

I was able to fix it by recreating the entire dataset from scratch copying every query, recreating every relationship, recreating all DAX tables, columns and measures and copy and pasting all report pages on the main dataset report.

This took a very long time as my dataset is quite very large (~100MB) and PBI Desktop tends to act very sluggishly when creating new columns or hiding columns, etc.

I hope now one else has to go through this, but if you don't have a choice, this can fix it.

till_obos
Regular Visitor

What I tried just now was saving my dataset as a template and then create a new dataset based on that.
The newly created dataset sadly suffers from the same conditions. 

Burningsuit
Super User
Super User

Hi Till,

I think this may be because you are running on an "old" Version 1 Workspace. If you go to Workspace Settings, Advanced, do you see the option to Upgrade the workspace ? like this...

Burningsuit_0-1631871944920.png

If so, upgrading the workspace may solve this problem, or creating a new Workspace and re-publishing the dataset to there may help.

Hope this helps

Stuart

Hey Stuart,

Thanks for trying to help out.

I don't seem to be running an older workspace.

till_obos_0-1631873809643.png

 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors