Excel Power Query Connector
The following article describes how data from different sources can be merged when analyzing data with Excel. In many cases, this data is available in CSV or XLS files that are saved in buildagil.
Copy link of the desired file.
In Excel, under the "Data" tab, select the From the web button in the "Retrieve and transform data" group.
Remove the extension of the link up to the file name and change app.buildagil to buildagil.sharepoint .
Insert the link in the dialog box.
If required, select the organization account and log in with the buildagil account.
Edit the desired elements in the preview and click close & load to import the file.
Data query in Microsoft Excel
Copy link of the desired file.
In Excel, under the "Data" tab, select the From the web button in the "Retrieve and transform data" group.
Remove the extension of the link up to the file name and change app.buildagil to buildagil.sharepoint .
Insert the link in the dialog box.
If required, select the organization account and log in with the buildagil account.
Edit the desired elements in the preview and click close & load to import the file.
Updated on: 15/11/2024