SharePoint Sheet Connection Error: Invalid Credentials

[tiagosouza]

Hello everyone!

I'm trying to schedule the refresh of a DataSet but, when I try to configure the connection of the Web source, wich is a Excel Sheet stored at OneDrive, an connetion error is thrown.

I'm using the same Microsoft account on Power BI and OneDrive.

The error is:

Unable to update connection credentials.
Invalid connection credentials.

Details:

The credentials provided for the Web source are invalid. (Source at https://iftmedubr-my.sharepoint.com/personal/my_account_XYZ/Documents/1%20-%20PROJETOS%20POWER%20BI/....)

Please have this information ready if you choose to create a support ticket.

ActivityId: 3e577633-1d61-4e89-85ed-011f4ccfef3f
RequestId: 67ac3c68-fb7d-471c-9598-5a4794ffbf96
Cluster URI: https://api.powerbi.com
Status Code: 400

[lbendlin]

when I try to configure the connection of the Web source, wich is a Excel Sheet stored at OneDrive

Don't do that.  Use the SharePoint Folder connector instead.