Embed Power BI in Acumatica via Site Map

1. In Acumatica, go to the Site Map page (Search for Site Map)

2. Click to add a line. 

3. Enter the following:

   1. Screen ID = DS.BI.01.01 (ID must be unique)

   2. Title = <name of the dashboard> 

   3. Url box:

      1. Go to your Power BI service and locate the report or dashboard page you want to embed in Acumatica.

      2. Click File → Embed report → Website or portal.

         

      3. Select the “Link to embed this content”, copy it, and then paste it into the URL Acumatica box.  

   4. Workspaces = Dashboards

   5. Category = Dashboards

4. Save this Site Map page.

5. Go to your Acumatica Dashboards page, show all entries.
   These steps verify that access rights are still intact after the change. With the permission changes in 2024 R1, a custom report added to the Site Map directly will be Revoked for all roles, including the report designer.

6. Confirm. Do you see the new page (e.g. <name of the dashboard>)?

   • IF you see the new page then click it to open the page.

   • IF you do not see the new page go to Acumatica Access Rights by Screen.

     • Depending on your Acumatica version, if an administrative user adds a new site map node directly on the Site Map (SM200520) form, the system will automatically set the form’s access rights to Revoked for all user roles. Then the user should grant access to this form to particular user roles on the Access Rights by Screen (SM201020) form. Acumatica Access Rights by Screen shows how to grant access rights to pages.

Keywords: Embedding DataSelf Reports and Dashboards