Refreshed Failed - Power Bi - Dataset - Dataset Credencials - Web

[rzilli]

Hi All

I have an excel file on one drive linked with my Power BI Dashboard.

But when I try to update in web service is says:

The credentials provided for the Web source are invalid

When I try to change the method autentication it doesnt allow me to use Oauth2.

Basic and Anonymus gives me error too

Can you help me identify which one to use

[v-cazheng-msft · Accepted solution]

Hi @rzilli,

May I know which connector did you use to connect to the data source excel file? How did you get the URL to the Excel file? Did you remove /:x/r/ part in the URL?

You may refer to this blog: Credentials provided for the Web source are invalid - PowerBI - SharePoint Views.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,                                    

Community Support Team _ Caiyun

[Hariharan_R]

Hi @rzilli 

You need to use Oauth2 option and enter the credentials. 

Ref - https://5minutebi.com/2018/04/09/power-bi-using-and-refreshing-excel-datasources-with-onedrive/

Thanks

Hari

[rzilli]

Thanks for your help

The system doesn't allow me to use Oauth2

The file is on my one drive