I am having a similar issue when updating a report/dataset.
The dataset is from from excel sheet in Sharepoint.
I have published this report in power BI service
Everytime I am trying to update the report I receive the following error message
|Time:||Fri May 15 2020 13:23:46 GMT-0700 (Pacific Daylight Time)|
Failed to update data source credentials: The credentials provided for the Web source are invalid.
I am using "Basic" for authentication method. and the privacy setting is set to organization.
Any help would be appreciated.
Solved! Go to Solution.
Similar issue , need help
I have created a report using excel doc as web source from team site which works fine. When I published the report and try to refresh dataset from workspace I get Error "Processing errorThe credentials provided for the Web source are invalid. (Source at" . So I tried providing data source credential for dataset using OAuth2 authentication with Oragnizational privacy level , gives me similar error "Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at".
I am facing similar issue while deploying cube as dataset from vs to pbi site. I'm using windows authenctication and my datasource is sqlserver 2017. I have like 10 datasets to be deployed out of which 8 are success, but remaining 2 seem to throw "Refresh can't be scheduled because the data set doesn't contain any data model connections, or is a worksheet or linked table. To schedule refresh, the data must be loaded into the data model." I have tried updating permission settings, updating processing type of the datasets but still no luck. If I deploy 4 datasets on one day, I can't deploy the rest of them on the same day. However, If i try the following day, it works. I have tried restarting my servers but that too doesn't do the trick. My datasets deployments that point to QA servers seem to work, but ones on staging servers give me above mentioned error. I have compared permissions and settings of QA and Staging and they are exactly the same.
Any help would be appreciated!!
For refresh to work properly when connecting to a SharePoint Online data source using AAD OAuth, you have to use the same account that you use to sign in to the Power BI service.
For further information, you may refer the following document.
There was a known issue is going on with sharepoint, Please check once.
If it is not related to this, Please try to authenticate with the "OAuth2" and try to re-pro the issue.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
I've never seen Basic authentication be successful against SharePoint, it is generally OAuth if SharePoint Online or possibly Windows if on-premises.
Actually i don't see an option for OAuth. The only ooptions for authentication method I see are : Anonymous, Windows and Basic.
Am I looking at something wrong?
Which connector are you using?
What version of SharePoint are you using:
I am using Web version of sharepoint....so Sharepoint Online.
I am not sure what connector are you referring to....I am not using any connector as far as i know.
My apologies for these questions. Its the first time I am trying to deal with the refreshing.
Sounds like you are using the wrong connector. When you "Get Data" in your Power BI Desktop, you are using a connector. And in your case, you should be choosing SharePoint Online List versus something list SharePoint List or SharePoint Folder I believe
Thanks for the suggestion. I believe i have used sharepoint folder earlier.
I will give it shot with Sharepoint Online and see how it goes. I will update you what I find out.
Thanks again for the help.
Having the same problem. 14 months later. There must be a solution.
Where is OAuth in the connector settings in power bi service?
I'm reading I need that to solve my problem which is: Successfully connecting power bi desktop to an excel sheet on OneDrive/SharePoint but, after publishing to the service, the service generates errors when attempting to connect. I'm using the same credentials on desktop (which works) and pbi service (which doesn't)
"Scheduled refresh is disabled because at least one data source is missing credentials"
Hi, how di you get OAUTH option in Power BI scheduled settings, I only see the Basic and Anonymous, can you help me how can get Oauth option.
I am also getting same error.
The credentials provided for the Web source are invalid. (Source at https://zebra.sharepoint.com
I looked into the Sharepoint Online....but it looks like I have to make a list first on sharepoint that i can talk to using power BI.
Is there any way I can use my spreadsheet saved under documents in sharepoint as a source? and link to that using power bi?
Let me know if i am making any sense.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.