Currently I have an issue with Refreshing the dataset that I uploaded to the Power BI web service.Please note that it works and able to refresh the data totally fine in Power BI Desktop.The issue is in the data source connected to Odata Feed I wanted to get all of my Microsoft Planner task data with this method, and based on a few reference requires me to use Microsoft Graph Explorer. I am utilizing my organization account and have a Power BI pro license. The following error message is returned when attempting to refresh in Power BI service: I attempted to re-establish the credentials but the same error persisted. Other sources such as SharePoint and dataflow do not exhibit any issues and refresh properly. The error only surfaces from the Odata Feed connection where I utilized Microsoft Graph Explorer to retrieve the task data in Microsoft Planner.I tried connecting the data source (OData Feed) to a Power BI dataflow, also returns the same error. Any assistance would be highly appreciated, as I have spent the entire day trying to resolve this issue without any progress.

Denis_Diakov I'm useing company account.Use www.powerbi.comGo to workspaceChoose that datset, check "Settings" --> "Data source Credentials"Choose "OAuth2", pricvacy set at "Organizational".Hope this helps.

I'm getting the same issue too, have setup my connections to Graph in the Power BI desktop app to get an update of my Planner tasks. I can refresh the dashboard via the desktop app but can't get it to refresh via the Power BI web app so that its auto refreshes daily. I am using the same UPN/credentials in desktop and Web.

Hi AlinaYakymchuk, Sorry for the late reply. Actually now still no significant progress. I discussed with my company's IT team that handles office apps and they already contact directly to the Microsoft Engineers.The engineers provided a solution to directly embed the credentials in Power Query's M-code. This might also be possible to create a parameter so that changing the credentials will be much easier in the future. My issue with this solution is that actually my company blocks direct authentication from the PBI Service to the planner. It requires microsoft authenticator with two-factor authentication. I do not know with the condition of your company but you can try using this solution for your side. But I think you need to talk with your IT team to help on this too since there might be a lot of things to work on together. let token_uri = https://login.microsoftonline.com/ & "your tenant id" & "/oauth2/v2.0/token", scope= https://graph.microsoft.com/.default, tokenResponse = Json.Document(Web.Contents(token_uri, [ Content = Text.ToBinary(Uri.BuildQueryString( [ client_id = "your application id", scope = scope, grant_type = "client_credentials", client_secret = "your application secret" ] )), Headers = [Accept = "application/json"], ManualStatusHandling = {400} ])), access_token = tokenResponse[access_token], Source = OData.Feed(https://graph.microsoft.com/v1.0/planner/plans/1-Kv1mpx60WDf1gghCycyAgAHVRt, [ Authorization = "Bearer " & access_token ], [ExcludedFromCacheKey={"Authorization"}, ODataVersion=4, Implementation="2.0"]), #"Converted to Table" = Record.ToTable(Source)in #"Converted to Table" ----------------------------------------------------------------------------------------------------------Or you can register another App as below (add Delegated permissions) and update the Power Query(replace highlighted content), to check if you can only get data from the plan which the account has permission to access. let token_uri = https://login.microsoftonline.com/ & "your tenant id" & "/oauth2/v2.0/token", scope= https://graph.microsoft.com/.default, tokenResponse = Json.Document(Web.Contents(token_uri, [ Content = Text.ToBinary(Uri.BuildQueryString( [ client_id = "your application id", scope = scope, grant_type = "password", username = “your user account” password = "your account password", client_secret = " your application secret " ] )), Headers = [Accept="application/json"] ])), access_token = tokenResponse[access_token], Source = OData.Feed(“https://graph.microsoft.com/v1.0/planner/plans/MQ3EoFzvz0OblZ3MNtZZ2ggAEUmm”, [ Authorization = "Bearer " & access_token ], [ExcludedFromCacheKey={"Authorization"}, ODataVersion=4, Implementation="2.0"])in Source

I was having the same refresh problem because of invalid credentials process. What worked for me was using a local gateway instead of a cloud connection.

Hi , ChristianEvan33 According to your screenshot , it works well in the Power Bi Desktop, but in Power BI Service, it seems the credential you provide is not right. You need to go the Power Bi Desktop , and click "Transfor data"->"Data source settings" to see which credential you provide in Power BI Desktop: You need to keep the same both in Power BI Desktop and Power BI Service. By default , the "Ouath2" is using the Azure Active Directory(AAD) as a credential , if your datasouce is not used AAD as an autentication mode , you need to change the autentication mode in Power Bi Service. Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! Best Regards, Aniya Zhang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Failed to update data source credentials: The credentials provided for the OData source are invalid.

25 Replies

KenEddie
New Member
3 years ago
I'm getting the same issue too, have setup my connections to Graph in the Power BI desktop app to get an update of my Planner tasks. I can refresh the dashboard via the desktop app but can't get it to refresh via the Power BI web app so that its auto refreshes daily. I am using the same UPN/credentials in desktop and Web.
v-yueyunzh-msft
Community Support
3 years ago
Hi , ChristianEvan33

According to your screenshot , it works well in the Power Bi Desktop, but in Power BI Service, it seems the credential you provide is not right.

You need to go the Power Bi Desktop , and click "Transfor data"->"Data source settings" to see which credential you provide in Power BI Desktop:

You need to keep the same both in Power BI Desktop and Power BI Service. By default , the "Ouath2" is using the Azure Active Directory(AAD) as a credential , if your datasouce is not used AAD as an autentication mode , you need to change the autentication mode in Power Bi Service.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Mateus_dadalt
  Frequent Visitor
  2 years ago
  I was having the same refresh problem because of invalid credentials process. What worked for me was using a local gateway instead of a cloud connection.
- Anonymous
  Not applicable
  3 years ago
  Hi v-yueyunzh-msft,
  
  Could you please tell me how can we change the authentication mode in Power Bi Service?
  - v-yueyunzh-msft
    Community Support
    3 years ago
    Hi , Anonymous
    
    If you need to change the authentication mode in Power Bi Service, you can fo to the setting of the dataset and then click "Data source credential" .
    
    And if you actually need use the "OAuth2" , you need to click "Sign in" and login in a user who has the permission for this api.
    
    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
    
    Best Regards,
    
    Aniya Zhang
    
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
v-yueyunzh-msft
Community Support
3 years ago
Hi, ChristianEvan33

According to your problem description, it is successful in Desktop, I think since you encountered the error message related to "Invalid credential", the problem is still related to the credential cache of Odata data source on the service of your account, you can go to the "Manage gateway and datasource" page, find the data source definition of Odata data source, and click Delete.

After that, you go to the dataset setting interface, click edit credential to re-enter Odata's data source credentials for the dataset, and check whether you can successfully configure the data source credential connection.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
rbartles111213
Helper I
3 years ago
Glad I saw this post and was not the only one with the issues.

My fix -
In Power BI desktop, I hit transform data.
Then I hit Data Source Settings (top left).
Then on the bottom of the window that opens, I hit "Edit permissions".
Updated the login.
Hit close.
Close and Apply (top left).
Hit refresh.
Saved and published to my development workspace.
Then tried refresh and it all wen fine.
Used the pipeline and pushed to Test and then Production.

Hope that helps!

Rick
Tom_Y
Advocate II
3 years ago
I have the same problem. Not OData, but an excel file in Sharepoint. It refresh perfectly on Desktop but once I publish it Workplaces in Power BI Services it fails to refresh.
I have made sure that the credentials are correct (same for organization log-in, power bi desktop, etc).
I have tried both "web import" and "sharepoint folder", same failure.

Data source errorThe credentials provided for the Web source are invalid. (Source at https://company_name.sharepoint.com/sites/Projects/Shared%20Documents/file_name.xlsx.). The exception was raised by the IDbCommand interface.
Denis_Diakov
Regular Visitor
2 years ago
I have the same problem. Authentication on my power bi desktop works correctly, but when using power bi services, it shows a failure message: 'The credentials provided for the OData source are invalid.' I'm retrieving data from Planner. I've been reading a lot of posts, but I couldn't find a solution.
I hope that you have already found one. What was your resolution?
- Tom_Y
  Advocate II
  2 years ago
  Denis_Diakov
  I'm useing company account.
  Use www.powerbi.com
  Go to workspace
  Choose that datset, check "Settings" --> "Data source Credentials"
  Choose "OAuth2", pricvacy set at "Organizational".
  Hope this helps.
  - Sandeep13
    Helper III
    2 years ago
    Hey
    
    just want to thank you from all my heart you saved my day. thank A ton.
Yurii-Chahovets
New Member
2 years ago
Any updates?? PowerBI team what do you think? Why it works in the PowerBI desktop but doesn't work in online
rbartles111213
Helper I
2 years ago
I had this issues before and I noted what I did to resolve it above.
However more recently I had the issue on another file and I logged in locally in transform data and edit credentials and all was good.
In the cloud it kept giving me the error in our Test workspace.
I deleted the file from test and pushed it again from Dev and BOOM! All good.

Looks like Power BI kept it in the cache or something.

Rick
- Yurii-Chahovets
  New Member
  2 years ago
  Did you try to get data from azureAD?
  - rbartles111213
    Helper I
    2 years ago
    Data was using my AD creds to get data from Databricks.
Ashish_Mahato
New Member
1 year ago
My take on this was to uninstall the On-Prem data gateway, as the service was not installed for this.

After uninstalling, I installed a fresh copy from Microsoft instead of the suggestion from the Power BI.

After installation, I configured the details for the gateway to use in Power BI.

Then, Manually set-up each database for MySQL with the same name (for no confusion), and connected the and applied the new gateway.

This helped in resolving the issue and now my database is connected.

This took me 2 weeks to find the answer.

Thanks for this community!