cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Some users: Failed to load [data source]. An unknown error occurred.

I have an app created with OneDrive for Business that I use with my students. I've shared the folder with the excel file with them. When some of my students open the app, they receieve the error: "Failed to load TableStudentName. An unknown error occurred." The really annoying thing is that it doesn't happen for all of them. I've checked that the individual students have read permission (they're not writing to the spreadsheet at all) and that the folder has been shared with them.

 

Any ideas on what might not be working?

3 REPLIES 3
Community Support
Community Support

Re: Some users: Failed to load [data source]. An unknown error occurred.

Hi @Anonymous,

 

So the issue here is users with read permission would have issues loading the Excel table?

Have you tried to change the permission to Edit and check it again?

There is an old thread talking about the same error:

Shared users - Problem loading OneDrive Data

Which should be resolved.

 

And from my testing, there is no issues connecting to the Excel table with Read permission configured.

If you are using OneDrive For bussiness, please share the file directly, follow the following guide to configure the permission:

Share Excel data used by your app

For more information, see Share OneDrive files and folders.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ianrimmer67 Helper II
Helper II

Re: Some users: Failed to load [data source]. An unknown error occurred.

Hi 

 

I have previously experienced the same issue and since the latest powerapps update, our users are getting the following error message when opening the apps:

 

Capture.JPG

 

 

tlt
Frequent Visitor

Re: Some users: Failed to load [data source]. An unknown error occurred.

Same here... the data connection issue is a huge problem.

 

For my case, I set the permission to "all user in my organization can view" for excel datasource and the app permission to "all user in my organization can use".

 

It works for a few weeks but sometime other users got a message: "Failed to load Table_xxx"

 

Now, all user cannot load the data.....I am trying to set the datasource to " can edit" and see what will happen.

 

However, I feel bad to do that even if it works, since other users may have a chance to modify/delete my datasource.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (8,703)