cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meenakp
Resolver I
Resolver I

Error when using Power BI dataset as datasource - "Cannot load model"

Hello,

We have one specific user who gets error as "Cannot load model. We couldn't connect to your model in the Power BI Service. The dataset may have been deleted, renamed or moved or it is possible that you don't have permission to access it"

 

He is a PRO user. He is logged on using same id in PBI Desktop and Service. He is using June version of PBI Desktop.

In PBI Desktop, when he does "Get data> Power BI datasets", he can see the list of datasets. But when he chooses a dataset he gets error as above.

He has "Build" access to this dataset. He CAN create report in Service based on this dataset, but cannot access it via PBI Desktop.

 

There is another dataset for which he is the owner, and he cannot use it as a datasource either in PBI Desktop.

 

This problem occurs only for this user. We have other users who have "BUILD" role to a dataset, and they can use such dataset as source in PBI desktop.

 

Please advise some solution. Thanks!

1 ACCEPTED SOLUTION

I raised a MS ticket. 

It turned out that user being on Windows 7 OS is the issue.

MS recommended to upgrade to Windows 10 OS and that should solve the issue it seems.

View solution in original post

9 REPLIES 9
amoto
Frequent Visitor

We are experiencing the same issue, the user is the owner and adm of the datasets, 

the datasets are in the PBIService working properly and the reports as well.

.- The issue appears in PBI Desktop,. either for Reports pointing to PBI service loaded Datasets or new Data trying to get data from PBI datasets appears the same error "cant find, locate or you do not have permission to access to the dataset", 

 

We need to solve it, pls, any suggestion is more than wellcome

I raised a MS ticket. 

It turned out that user being on Windows 7 OS is the issue.

MS recommended to upgrade to Windows 10 OS and that should solve the issue it seems.

View solution in original post

amoto
Frequent Visitor

Dears,

 

Yes, the problem disappears when connecting the dataset in another computer with Windows10.

 

I wonder why Microsoft forces to this updagrade and handicap the continuity of works for users willing or needing to have other OS in servers,.,,

 

thanks for your support.

Thanks for the update @meenakp

Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

v-yingjl
Community Support
Community Support

Hi @meenakp ,

Seems like cannot determine the specific reason because it only happens on a sepicifc user. Perhaps you can change to another network environment or re-install power bi desktop to check this user again. 

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

AllisonKennedy
Super User
Super User

Have you tried raising a support ticket with Microsoft? https://powerbi.microsoft.com/en-us/support/

Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy, I haven't raised a ticket yet on the hope i would get answer in the community. If no helpful answers, thats my next step... 

parry2k
Super User
Super User

@meenakp it is strange, can you check if he is part of workspace, although he has build permission it should work but trying to see what else it could be?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k, He is not a member of the workspace in the 1st scenario, but he has build access.

[Other user with same access can access the dataset in PBI desktop.]

 

In the second scenario, he is a member of that workspace and he publishes reports, but he cannot sill access its 'dataset' in PBI Desktop.

Its indeed strange!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!