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
Onedrive refresh is special, in short, there may be a delay:
It can take Power BI up to 60 minutes to refresh a dataset, even once the sync has completed on your local machine and after you've used Refresh now in the Power BI service.
So you can wait for a while to see if the refresh is successful.
Reference:Data refresh in Power BI - Power BI | Microsoft Docs
Considering that your data is stored on onedrive, I think you also need to confirm whether all users can access it. If they can’t access the underlying data source, it will be useless even if they have permission on powerbi.
Are you calling the api through the Is_Prod parameter to see if it is published to the service? This looks great, if you can go well.
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.
Thanks again for responding.
I granted my users access to OneDrive as suggested. It did not have an impact. I verified with one user that he could indeed access and open one of my files.
For the parameter, I created the parameter under "Transform Data". I use the Gateway option to ensure that it is set to "TRUE". I also tried reloading my report through the desktop application with it set to "TRUE" and republish the report. It did not impact the "Unable to Load Model" error.
Here is how my Advanced Editor looks for my inbound data:
I thought I had found the issues, as on several files I needed to change the transformation. When I reviewed all the code, I noticed that it had changed and it appeared that the code would always look at my files on my PC. I changed the code back and republished the report, but it did not impact the end user.
I have verified that the Gateway is using the correct parameter and I verified that the dataset lineage is correct. All the files are coming from my OneDirve account.
i mentioned before ,the ability to flip between my laptop for data and OneDrive is important, in that my home office has a fair user policy on Internet usage. So, I would prefer to develop and test using my local data, then publish using OneDrive data. I have been publishing with a parameter FALSE, then using the gateway to change the parameter to TRUE. I then perform a data refresh.
If there is another way to accomplish my goal without needed to change all my data feeds, I'm happy to try a different technique, if this is what is causing the issue.
In the gateway, I have mapping created for both my personal laptop and OneDrive.
Jennifer
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
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