...
You can now run filters on the data as required or write your transformations using the M Language using Query Editor's Advance Editor
...
7. Example of a Time/Date Filter
8. Once all the required Filters are run → Close & Load the data to Excel
...
Updating an existing Excel OData report
...
- Open Excel go to→ Data tab → Show Queries
2. If you aren't connected to the Odata you will get the below error and need to follow the required steps as outlined in the screen shots below.
3. Power Query Editor will open any filters will be listed in the applied steps → right click on the settings icon next to the required filter → Edit Settings option
4. Update the required settings
5. Close & load
TIPS for using Excel Get & Transform
...
2. Click Edit Permissions → Edit credentials
→ OK
3. Update the required details → Save → Now you can "get data" for this organisation
Edit
...
loaded OData
1. Edit Queries will allow you to filter the data downloading into the reports. Select Query tab
Refreshing Data
To Retrieve new data from BUZ select "Refresh" from your Design tab
Please contact support@buzsoftware.com.au for any further questions.