Gateway Connection and Data Source Credentials are missing from the Datasets Menu

[tinna]

Hi, I cannot set datasets refresh schedule. The error message "You can't schedule refresh for this dataset because the following data sources currently don't support refresh:" But there is no datasources listed. And also the Data Source Credentials items are not shown, so I don't know which data source has an error. 

When I manually refresh this Datasets, the status is completed.

Please help, thanks.

[v-xiaoyan-msft]

Hi @tinna ,

Are you adding a data source to the Manage Gateway page?
Can you update the gateway to the latest version or restart the gateway to see if the problem persists?

Best Regards,
Community Support Team _ Caitlyn

[tinna]

Hi @v-xiaoyan-msft ,

Thanks for your response.

Actually the datasource was added to the gateway for some time(almost a month) and everything was fine.

On weekend 6/11 the gateway machine was shutdown and I turned it on at 6/13. Since 6/13, some strange issues happen:

1. Some of my datasource cannot connect:  there two Web data source from my Sharepoint file and one PBI Dataset. Both with the same error message below.

2. The Gateway and Datasource Credentials items are missing from the Dataset menu.

Issue 1. Cannot connect to Sharepoint file and PBI Dataset

There are 3 files from Sharepoint that used in this Datasets, but 2 of them cannot connect (cannot adding the data source after deleted it because the gateway connection always return error-as above picture).

The 1st file Master_MO_KPI.xlsx status is online, it was located in the same location as the other two. But I am not sure that I can add it back if I delete this datasource.

Issue 2. The Gateway and Datasource Credentials items are missing

This case seems happen when one of the datasource of the current gateway used by the data set has an issue.

If the datasource used by the gateway has no issue(Dataset refresh completed), but the Gateway and Datasource Credentials are missing, I just need to refresh(F5) this Datasets page becomes normal and shows Gateway and Datasource Credentials.

After page refresh(press F5)

I have restart the on-premises personal gateway and the version now is 3000.114.6.

Btw, the gateway is using another AD account. This power bi datasource and sharepoint are using my AD account. I also installed on-premises in my own laptop and those sharepoint files can connect successfully.

But it was working fine using the gateway with another AD account, don't know why it cannot connect now.

Appreciate for your help.

Best regards,

Tinna