Forum Discussion

Elofly's avatar
Elofly
Frequent Visitor
5 years ago

Data Source Error - Credentials cannot be updated

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

Data Source Error

5 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    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's avatar
      Elofly
      Frequent Visitor
      5 years ago

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

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

    • Elofly's avatar
      Elofly
      Frequent Visitor
      5 years ago

      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's avatar
        v-deddai1-msft
        Community Support
        5 years ago

        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