Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Resident Rockstar
Resident Rockstar

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors