Auto Refresh disabled. Data source credentials missing

[airwreck]

I am trying to set up a report to auto refresh but I am unable to.

The settings page shows the 

My data comes from a sharepoint site

Where should I go to fill in these misisng credentials. 

A Gateway is not an option for me, I just need to know where I can add the missing credentials 

[parry2k]

@Helena_P good to hear, I would recommend post the solution here so that others can learn from it and mark respective reply as a solution.

[parry2k]

@Helena_P That's the problem, if you have a local Excel file you need a Power BI gateway and then you can set the credentials, but the 2nd one is working coz the file is in the cloud and no gateway is required. 

[Helena_P]

HI , I managed to fix the issue 🙂

[parry2k]

@Helena_P So something is going on there. Is this excel file on-prem or in cloud?

[Helena_P]

the report based on sharepoint list and excel (here is saved localy on my machine), 

second report based only on excel is saved on sharepoint (cloud)

[parry2k]

@Helena_P Are you sure there is only one data source in your dataset and that's sharepoint? Just confirming.

[Helena_P]

just checked it and the second file is an excel file which hasnt been moved or renamed since I created it.  The other report I have is based on other excel file and this was renamed, but I have updated the source and only later the refresh crashed 😞 

[Helena_P]

the data sorce hasnt changed as one of the reports is based on the list created in sharepoint. I am able to refresh the reports in desktop but I need the report to refresh itself and without credentials I cant schedule a refresh.. however the dataset credentials are inactive.. 

[parry2k]

@Helena_P what are the data sources in your dataset? On-prem or Cloud?

[Helena_P]

it turned out, I needed to refresh datasource 😉

[Helena_P]

HI all, I have the same issue. Please note the dataset credentials is inactive so we cant simply go there and update. Could you advise where else we can update this? 

[Syndicate_Admin]

You go to the data source settings, then you go to Data Source Credential and click on "Edit Credentials" in this case I have two connections, you enter your authentication and that's it.

[parry2k]

@airwreck sharepoint is the only source in your file or there is another sources too?

[airwreck]

Correct data is only coming from sharepoint

[Syndicate_Admin]

Hello, the same thing happened to me when I added to my data model an excel (local) file as an additional source. That generated the same error as the one to show and the only way to solve it was to eliminate the excel from the model.

Regards.-

[v-lionel-msft]

Hi @airwreck ,

Has your problem been solved? 

You check whether the data source has changed, such as the data file has been deleted.

Because Power BI Service will read your connection information and generate data source credentials, you cannot manually configure data source credentials if your data source is deleted.

If the data source has not changed, try to refresh the .pbix file in PBI Desktop, If it can, please publish the .pbix file again.

Best regards,
Lionel Chen

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