Forum Discussion

AlexHuang's avatar
AlexHuang
New Member
6 years ago

Issue with refresh data from onedrive

Hello Everybody!

I am facing an issue to connect PowerBI Service to an Excel file on OneDrive for business.
I uesd onedrive files to create visuals on Power BI Desktop and the Desktop version can refresh data without any issues.
However, when I published the report to Power BI service and tried to refresh the Dataset, the changes would not reflect.
I got the following error: “Failed to update data source credentials: The credentials provided for the Web source are invalid.”
I guess it was caused by wrong authentication method, maybe I should choose Oauth2, but I can't find Oauth2 option in authentication method, it only show "Anonymous" and "Basic" option.

My question is:
1. Can I ues onedrive files to creat visuals and refresh in Power BI service?
2. Is Oauth2 option depend on data source type? How can I choose Oauth2?

Anyone had a similar problem and knows how to solve it?

Thank you!

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi AlexHuang ,

    I have had some issues before where the url allows it refresh in Power BI Desktop but doesn't give the option to use OAUTH in Power BI Service. In my case it was because of the URL. Open the excel file in the excel desktop => File => At the top it shows the path where the file resides for example Microsoft >> Shared Files >> Folder click on it and copy the path => remove "?web=1" from the url and use this as the datasource. This should allow you to configure oath.

     

    Hope it helps,

     

    Kind regards
    Joren Venema

    Data & Analytics Consultant
    If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily. 

    • AlexHuang's avatar
      AlexHuang
      New Member
      6 years ago
      Hi Joren: Thank you very much! I have removed "?web=1" and url ends with ".xlsx", I can connect data in Power BI Desktop. But still can't find Oauth2 option in Power BI service.
    • AlexHuang's avatar
      AlexHuang
      New Member
      6 years ago

      Hi Xiaoxin:

       

      I have chose  Organizational account in Power BI Desktop and able to connect with data.

      Url should match the requirement.

      But I only find Anonymous and Basic option in Power BI service.