...
2. Go to → New Query→From Other Sources → From OData Feed
...
3. Type in your URL → https://api.buzmanager.com/reports/ Organisations Code
...
4. Sign in using your credentials
Your user name will have your organizational code that we found in the first step in the Reports section (xxxx) forward slash your username for BUZ. Can be found in BUZ under Reports -> Right hand side ( 5 Character code) or contact BUZ Support to supply your Organizational Code. (Example: BUZDM/ support@buzsoftware.com.au)
...
You can now run filters on the data as required or write your transformations using the M Language using Query Editor's Advance Editor
Example of a Time/Date Filter
...
1. Excel → Data → New Query button ! → Drop Down → Data Source Settings
...
2. Click Edit Permissions → Edit credentials
...
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
...
Errors loading the data
Clear the permissions and try again
...