I dataset not refresh in Power BI Service.

[Anonymous]

I have dataset it is not refreshing in Power BI Servcie getting some error. But when i download PBIX file and open in desktop it refreshing getting no issue. I am publishing the PBIX Manually again to update the data from Power BI Desktop. 

Please find the below error message. I am unable to understand the error can anyone help on this error.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the OData source are invalid. (Source at https://fef.amsua0202.manage.microsoft.com/ReportingService/DataWarehouseFEService/mamApplicationIns....)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"OData"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://fef.amsua0202.manage.microsoft.com/ReportingService/DataWarehouseFEService/mamApplicationIns..."}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"OData\",\"path\":\"https://fef.amsua0202.manage.microsoft.com/ReportingService/DataWarehouseFEService/mamApplicationIns...\u0026$skiptoken=2250960\\u0026api-version=v1.0\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: maminstances.
Cluster URI: WABI-US-NORTH-CENTRAL-F-PRIMARY-redirect.analysis.windows.net
Activity ID: 6ef30b9e-41f2-438c-b7e6-3b595dccbd96
Request ID: 50589c4d-4a83-f2b3-6cf6-49a83e10f6d8
Time: 2021-08-24 10:52:23Z

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[v-xiaotang]

Hi @Anonymous 

Please go to Manage Gateways section, find the OData data source, ensure the "Skip Test Connection" is unchecked, then click on Add button to see if the data source connection is indeed successful.

Also go to DataSet Settings section to find the problematic dataset, ensure all settings are fine. Then do manual refresh by Refresh Now to see if the same issue occurs.

Best Regards,

Community Support Team _Tang

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

[arvindsingh802]

As per error message The credentials provided for the OData source are invalid, you need to update your credentails in datasource of the gateway.

It look like current account does not have access to Table: maminstances, so updating the access of existing account should resolve the issue.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

[goncalogeraldes]

Do you have the Gateway installed? If yes, do you have the credentials updated and does it show the message saying "The gateway is online and ready to be used"? If you dont have the gateway yet please check the following link for downloading it:

https://powerbi.microsoft.com/pt-pt/gateway/

If you already have it, try checking if it is up and running okay!

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes