In each of the macros, there is a simple 3 step process:
Share – Click on the share link/button in the BI/Dashboard system
Copy the embed URL
Paste – In Confluence, paste the embed URL. If required, set the width and height of the dashboard in the macro settings
Examples of all macros and how they are used is below: