How to Open a Mavim Portal Report in Power BI
To open a report from the Mavim Portal in Power BI, you need to configure Basic Authentication and retrieve the report URL.
Step-by-Step Instructions:
1. Enable Basic Authentication on the Portal
- Log in as Admin to the Portal:
https://<yourportal>.mavimcloud.com/portal/admin
- Go to the General tab.
- Enable API Basic Auth.
- Set a username and password.
2. Set Authorization (if using groups)
- If your Portal uses groups, you must also set the API Basic Auth | Authorization field.
- To find the correct User ID:
- Go to the Users tab.
- Locate a user with the Administrator role.
- Use the ID shown in the last column (e.g., ID = 22).
- Go to the Users tab.
3. Get the Report URL
- Open the desired report in the Portal.
- Click the Power BI JSON button to copy the report URL.
4. Open in Power BI
- Open Power BI Desktop.
- Go to Get Data → Web.
- Paste the copied report URL.
- Choose Basic Authentication.
- Enter the username and password you set earlier.
- Click Connect.
The report will now load into Power BI.