Thank you for your reply. But I am facing the problem of data source error as the query data source is from one of the workbook in the computer. Hence, the another users cant update the data in the workbook. May I get the solution on this matter?
The data source for the excel power query file are from the worksheet in the same workbook. I have change the data source to the link of the excel file in onedrive but the power query still produces "DataSource.error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."
I am not sure is the way I change the data source was correct or not. Hence, I would like to ask for your help to solve this issue.