We have a shared OneDrive and several Dashboards with PowerQueries. At the moment, it only works when the user who created the PowerQuery updates it, as the path is "C:\Users\Dralky\..." How can I get it to run from either whatever user is on it ("C:\Users\%USER%\..."), from the path of the current book, or otherwise get around that?
Full initial query line:
Source = Excel.Workbook(File.Contents("C:\Users\Dralky\OneDrive folder\sub folder\file.xlsm"), null, true),