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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

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?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.