Pre-requisites:
- This guide presumes that you have a Tug (connector) already set up, otherwise see: Setting Up a Tug in Tugger. (These guides detail setting up the Tugger connector and importing into Power BI Desktop, which can be skipped.)
- If your guide is not available in the above link, then try the more generic guide here
The Report Credentials contains everything you need to export your data; it also provides the important security information for Excel (and Power BI Desktop) to correctly import your data ready for viewing in your custom reports.
In addition, the OData URL and the Authentication Details are all that you will need to import your data into Excel, see: Excel Users: Import OData Into Excel.
The example: the image below, shows a Teams connector, but other than having 'microsoftteams' in the URL link name, the other connectors will be the same with only the URL differing slightly.
You'll likely notice the highlighted template, for Power BI users, they can use this to import their data; this feature isn't available for Excel users.
To continue with importing your data into Excel, the guide here details the steps: Excel Users: Import OData Into Excel.
(If you wish to Import your data from Power BI Desktop to Power BI Online, please see the appropriate guide: Setting Up a Tug in Tugger.)