Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
HI @AlexHuang,
I'd like to suggest you take a look at the following link about use overdrive on business file as source of the report:
Use OneDrive for Business links in Power BI Desktop
Regards,
Xiaoxin Sheng
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.
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.