Hi,
I have a file on Sharepoint (Office 365) that has a power query which creates a table (TableB) that uses another table (TableA) in the same file as its source. If I open it In App, I can do a RefreshAll and TableB is updated if the contents of TableA have changed. However, if I try to do the same with the file open in the browser, I first get a warninin stating: "Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source. Do you want to refresh the workbook?". If I click on Yes, I get an error titled "External Data Refresh Failed" saying "We were unable to refresh one or more data connections in this workbook.
The following connections failed to refresh: Query - qryUpdate", which is the name of the query that powers TableB.
I created the file, I own it, I have permissions to delete/update/create files and folders in my department's Sharepoint area.
This is an issue with any file containing a Power Query that I try to update. One final thing, I used to be able to refresh these queries until a few days ago.
I have tried so many different approaches suggested by posts on forums but none have worked. I feel it must be some sort of permissions issue but I am a total newbie to Sharepoint so I do not know how to fix the problem. I am an experienced programmer, especially in Excel(desktop), so I find it frustrating that something that should be so easy cannot be done. I have even looked created a Typescript macro, which just has one functional line
function main(workbook: ExcelScript.Workbook) {
workbook.refreshAllDataConnections();
}
This runs without error but does not update the table.
Any help would be appreciated. I have attached a basic example. In the real product there are many more columns in TableA and TableB has had calculated columns added.
Thanks,
Chris
