OneDrive for Business Error

[FoDelement]

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)

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

[v-xida-msft]

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,

[DM18]

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