Re: Share a report with a lot of users

FelipeCosta · ‎10-28-2019

Hello, we currently have a PBI Premium license and need to share the report with ~400 users within the organization. I have a list of all accounts in a spreadsheet.

Is there a more effective way to share with all of the 400 users using, say, a PowerShell script? Adding one by one in the UI takes too long.

v-eachen-msft · ‎10-28-2019

Hi @FelipeCosta ,

You could publish it to web but security cannot be guaranteed.

You could also use PowerShell to batch process it.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

FelipeCosta · ‎10-30-2019

Could you provide a link that has the PowerShell command? That's exactly what I need.

I couldn't find it anywhere.

Seth_C_Bauer · ‎10-28-2019

@FelipeCosta This is where Active Directory comes into play. I would recommend you have an AD group created and you can share with that group. Than IT or whomever manages your users can handle the user management part (coming/going of personnel) and you only have to share 1x with 1 group.

Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG