Forum Discussion
Unable to Load Model error message
Hi, zz99b0
In fact, my previous answer focused on the issue of permissions, and I also reminded you to check the permissions of the workspace and datasets. But it seems that you didn’t care about this, and we ended up going in another direction. But I'm glad it was resolved in the end.
Generally speaking, if it is a simple report sharing, the permissions of the dataset are set by yourself when sharing, but if the user is granted access to the workspace, the permissions of the dataset will be automatically defined according to the access of the workspace.
If you don’t want users to modify or create your reports, you can change user access to 'viewer'.Different datset permission:
Workspace role capability:
Reference: Roles in the new workspaces
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, zz99b0
It's so strange. If you say that some users can open the report normally, then it actually shows that your report should be no problem,otherwise no one can open. Can you show me the gateway connection information and data source refresh information (shadow privacy) in PBI Service? Are you using a web connection to connect to the data? Is your user an internal user or an external user? Try to let the user log in in private mode(browser). And I need more information to judge.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
More information, as requested.
1. I was on a status call this morning and my users who once was successful accessing the report can no longer access the report. Now (otherthan myself), everyone is getting the same "Unable to Load" message.
2. Yes, when the Parameter is set to TRUE it is using a web connection.
3. Yes, all my users are internal to our company.
4. Here are the gateway screen shots:
Local Data mapping should happen when my Is_Prod parameter is FALSE.
I'm using OAuth for authentication .. should it be Anonymous?
Does this help? Thanks again, you are terrfic to hang w/ me on this issue. This is baffling to me and I know I'm doing something "dumb" and will bang my head when we figure it out.
Jennifer
Thanks again for all your assistance. I apologize if you felt I was ignoring your recommendations, it certainly was not my intention, as I have alot vested in making this work given the visibility.
I'm am still new and thought I was following what you suggested. I had checked permissions on the report, data sources, gateway, and OneDrive. And to be totally honest, workspace itself didn't connect in my brain, since I had granted access to the report itself.
I do appreciate all your help.
Jennifer
Hi, zz99b0
In fact, my previous answer focused on the issue of permissions, and I also reminded you to check the permissions of the workspace and datasets. But it seems that you didn’t care about this, and we ended up going in another direction. But I'm glad it was resolved in the end.
Generally speaking, if it is a simple report sharing, the permissions of the dataset are set by yourself when sharing, but if the user is granted access to the workspace, the permissions of the dataset will be automatically defined according to the access of the workspace.
If you don’t want users to modify or create your reports, you can change user access to 'viewer'.Different datset permission:
Workspace role capability:
Reference: Roles in the new workspaces
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, zz99b0
The gateway connection and data source connection are normal. I see that your data sources are many and they are all of the web type. Then this may be the cause of the problem. You need to ensure that users in the organization can access every URL . Because there should be a mixed query, as long as one of them fails, the entire model may not be loaded.
Can you refresh the report successfully?
Best Regards
Janey Guo
Thanks again for hanging w/ me.
1. The data says it refreshes and I can access the report and I see the new data through web browser (as if I'm a user).
2. So, not sure which link above you wanted me to check, but here is what I have:
- On the report, I only have granted access to specific people, as this report is not open to the entire organization. Do I need to create a link for "People in your organization"?
- On the dataset, I again, only granted direct access to specific people. The same list as the report. Do I need to create a link?
- On the OneDrive, I also only granted direct access to specific people. The same list as the report.
3. I am meeting w/ one of my end users late this afternoon to test each link. Three questions:
- Because I have mapped in the gateway for my personal harddrive, do you know if it checks those links eventhough they are not referenced in the published report, but is part of the data transformation M code?
- On my Gateway Cluster Settings .. I do not have any of the 3 checkboxes selected. Do I need to check the "Allow user's cloud data sources to refresh through this gateway cluster. These cse could data sources do nt need to be configured under this gateway cluster."
- Do I even need a gateway? I vaguely recall reading that perhaps if the data is on One Drive, I don't need a gateway? Would it be easier if I moved the data to the SharePoint subsite that my workspace is on?
I will post back the results of testing each URL link on my data sources.
Thanks again!
Jennifer
Hi, zz99b0
You can try to turn on this feature, because you have both local data and cloud data. Query is generally mixed query. Even the data in the cloud will pass through the gateway.
Because you are using a web connector, you need a gateway even if the data is on onedrive.
Unless you are importing files directly in the service.
Like this:
You can also try to connect in anonymous mode in the web connector to see if it solves the problem.
The error message is not clear, we can only eliminate the problems one by one.
Best Regards
Janey Guo
I think I have it finally solved. Here is what I did:
- Created a new workspace
- Granted users access to the workspace. I had not done that previously. I only wanted users granted access to specific reports, as I knew my workspace would grow in the future and I need to be able to segregate users.
- Deleted my gateway altogether.
So at this juncture:
- Users are granted access to the entire workspace as a Member
- Users are granted read access to my OneDrive folder via "Links giving access"
I really wanted more constrained access as I do not want users creating their own reports at this point, as the data model is not bullet-proof. As you really must have a complete understanding of the data model. But it gets me past my existing issue.
Not sure this is the right answer, but at least I'm totally dead in the water.
Jennifer