Share report to bulk of groups in a single shot.

[Mano R]

Use case:

1. we have a requirement to add 149 groups in a single shot to the dashboard instead of adding one by one sharing option in the dashboard.

I have pasted the exact area where we need this functionality.

Please let me know if any way to achieve this functionality.

Thank you

[SumanthDosapati]

Hi,

You cannot share dashboards in bulk.

But if you want to share only a report and not dashboard then answer from @Musab Rasheed  will help you.

Regards,

Sumanth

[Mano R]

Where the relationship of the shared group and dashboard gets saved. the idea behind this ask is if we got the table then using the script we would be able to insert new records to that table which should provide access to all the groups for a specified dashboard.

[Jaspal Singh]

Did you check for pa_dashboards table?

[Mano R]

Hey everyone thank you for your support and help

Finally, I found the solution and it worked for me

Solution:

(pa_dashboards_permissions),This is the table that saves the relationship between the shared groups and the dashboard, so you can directly import the table has excel and fill out the necessary information for creating the record in the table I will provide you some sample images of how the record should be formatted in the excel.

after formatting the excel file save it and import into the table (pa_dashboards_permissions) and click on complete import all the records will be inserted and we can see all the groups are bulk uploaded in the dashboard sharing option.

Thank you

Mano.