How to give access to everyone who open a dashboard with direct query in workspace?

[xxkid]

Hello folks

I've builded a Dashboard with a data set imported by direct query, when I published the dashboard everything was fine, actually when I go to the workspace to see it, it works perfectlly:

Somehow when someone else tries to get into the workspace to use it, the dashboard goes like this:

Do you know guys, how can I to "inherit" my permissions to everyone who go to see the dashboard, and not give access profile by profile instead? I've been triying to solve it for hours but I'm not getting lucky.

Thanks a lot for your help.

[julienvdc]

Hey @xxkid  have you ever found a solution to your problem?

[v-luwang-msft]

Hi @xxkid ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @xxkid ,

You can give users access to the report in the Manage Permissions section of the report. After my testing, it does not require you to add the user to the workspace.

Also check that you have RLS configured，if you add users to the workspace and give them roles other than "viewer", RLS will not take effect.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Shahfaisal]

A couple of options:

1. Create an App and give all those users  access to the App - https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

2. Give all those users access to the workspace - https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-the-new-workspaces

For both the options, you don't have to go one user at a time, you can use groups when setting up access.

[xxkid]

Thanks a lot!

Just one quick question, what would be the process to give access one by one?

[Shahfaisal]

---

@xxkid wrote:

Just one quick question, what would be the process to give access one by one?

---

You can just click on the "Share" option and type the email of user(s) you want to give acces to.