Morta's API allows users to fetch data from each screen in Morta, whether its the list of hubs the user has access to or data in a table. However, users mostly use Excel to report on
two main types of data:
- Data in tables or views
- Audit logs
Prerequisite: please create a Morta API token to allow Power BI to read data from Morta.
VERY IMPORTANT Do not share the Excel file with anyone, before deleting the invoked function and query (as shown at the end of the section) since your Morta API Key can be used to access your Morta account via API