cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FoDelement
Continued Contributor
Continued Contributor

OneDrive for Business Error

Hello All!

As of this weekend, all Apps I have created are getting this error message when connecting to an excel file on OneDrive for Business.

 

 

Cannot read file from filesource. Dataset:b!J40iMds6nUmAGZ0rUdETg1C0TWQnxzdJtmxSKhn08ghZhOVfk0vWQ6SMHqgKuda9.01CRW3MHBBSWVL73QMNRBLJBM7AJJ4IGEW Status:Forbidden Message:Forbidden
clientRequestId: 641e5d1f-de7b-476e-97c7-fc1797efbd37
serviceRequestId: 641e5d1f-de7b-476e-97c7-fc1797efbd37;641e5d1f-de7b-476e-97c7-fc1797efbd37;641e5d1f-de7b-476e-97c7-fc1797efbd37;641e5d1f-de7b-476e-97c7-fc1797efbd37

Session ID: 727373dc-c90d-4b28-8428-0e593c1fe492

 

 

All my apps were working fine up until this point. I created a new app, connected to a new excel file in my onedrive, and I get the same error.

 

I believe we made a change over the weekend that restricted unmanaged devices connecting to O365, but this is coming from device that are managed and on the network. (Conditional Access in Office 365 by selecting "Allow limited, web-only access" in the SharePoint Admin Center, under "Unmanaged devices")


(We were seeing this in Chrome as well, which required an add-in to fix)

thumbnail (1).png

 

Does this mean, with this setting turned on, we can't use onedrive anymore with powerapps? 

 

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @FoDelement ,

Some other users in this Community have faced similar issue with you. The Product Team is investigating this issue, if this issue is fixed, I would reply here.

 

As an temporary solution, please consider turn off the "Enable enhanced Microsoft SQL Server connector" option, and turn on the "Formula-level error management" option within Advanced settings of App settings of your app, then re-publish your canvas app, check if the issue is fixed.

 

If the issue still exists, please consider remove the Excel table connection from your canvas app, then re-add a new connection to it with your proper credential from your canvas app, then re-publish it again, check if the issue is solved.

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DM18
New Member

How was this resolved? I am trying to create my first app and trying to  connect to an excel file on OneDrive for Business and getting same error as below - 

 

 

Cannot read file from filesource. Dataset:b!R0O6e6d9gkGh4W-9TKukHXCMJhkMAt9Gg9rVU55zlLaoaZJe-P5xQp7qT4ICBhCJ.01AIBEIXDOMO6UEKEODFFJHUQYA4CRE7HQ Status:Forbidden Message:Forbidden
clientRequestId: 658e0534-e45d-4b4c-a88d-ff31a0d87e23
serviceRequestId: 658e0534-e45d-4b4c-a88d-ff31a0d87e23;658e0534-e45d-4b4c-a88d-ff31a0d87e23;658e0534-e45d-4b4c-a88d-ff31a0d87e23

Session ID: 218e4ebc-2238-4250-a2ab-96b6dd16c11a

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,707)