Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dataset refresh issue with office 365 excel

Hello All,

We are using "Web" data source type to pull the data from Office 365 excel. I am able to refresh data from excel through "Transform data" in Power BI Desktop.

 

When we deployed it to My workspace, dataset is not refreshing. Following are the error(s) we are getting:

1) If we Anonymous Auhentication method then Error is -
Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://...)

2) OAuth:
Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at

Let us know how to resolve this issue.

Thanks,
PBI V2

 

Need Help

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

    It sounds like you are having trouble refreshing data from an Office 365 Excel file in Power BI Desktop. The error messages you are receiving indicate that there may be an issue with the credentials you are using to access the data source.

    Here are some steps you can try to resolve this issue:

    1. Check that the credentials you are using to access the data source are correct and up-to-date.

    2. Make sure that the data source is set up correctly in Power BI Desktop, including any necessary authentication settings.

    3. Try using a different authentication method, such as Windows authentication, to see if that resolves the issue.

    4. Check that the data source is accessible from the location where you are deploying the dataset.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous ,

     

    Since you are able to refresh on power query, and not in service, 

    you need to update your credentials in service with same credentials you provided in desktop.

    After updating, I think it will refresh.

     

    hope this helps