Data Source Error - Credentials cannot be updated

[Elofly]

Hi

I am trying to update a report and dataset but receive this error message:

Last refresh failed: Wed Feb 10 2021 11:51:57 GMT+0100 (hora estándar de Europa central)
Scheduled refresh has been disabled.Hide details
Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: 6b9b7882-2525-4f50-abc4-25eab803ded9
Request ID: c8e52207-f59b-8ac7-f536-44bed8374cca
Time: 2021-02-10 10:51:57Z

But Data Source credentials cannot be edited as they are in grey.

I do not use gateways and do not need one.

I have no idea why.

Thanks in advance for any help

[v-deddai1-msft]

Hi @Elofly ,

Did you use gateway in your dataset? Did you configure right credential in gatway settings? Did you choose the right gateway on the above?

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

Best Regards,

Dedmon Dai

[Elofly]

As a mentioned in the previous post, I do not use or need a gateway.

[lbendlin]

Please provide more details. What type are your data sources?

[Elofly]

Hi, I have a SQL Azure database and a sharepoint.

I have tried to do some tests yesterday and the issue seems to be when I try to load an EXCEL file as a new source of data. When data is loaded and i try to publish, the dataset changed and gets this error message. I cannot re-set my configuration because then it is greyed up.

[v-deddai1-msft]

Hi @Elofly ，

Is the new excel file on-premise or in sharepoint? If you add a new data source on-premise, you need to use gateway, and configure credential in gateway settings.

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

Best Regards,

Dedmon Dai