Forum Discussion

gissah's avatar
gissah
Regular Visitor
4 years ago
Solved

In Excel Via Get Data From Power BI Dataset

I have dataset in a workspace and users are trying to connect from excel using from Power BI. They can see some of the datasets in Excel but not all of them. what am I doing different that some are a...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi gissah ，

    It seems likely to me that you have RLS permissions configured in your report. What you are describing is entirely consistent with RLS, where users with edit and above permissions on a dataset have access to all data in the report when using RLS. Contributors, on the other hand, have edit access to the report.

     

    Best Regards

    Lucien

gauthamboppana's avatar
gauthamboppana
Solution Specialist
4 years ago

gissah  - Does the Users have access to the workspace in which the data is published to? Also, make sure in the dataset settings the option "Make it Discoverable".




Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

 

gissah's avatar
gissah
Regular Visitor
4 years ago

Yes sir and thanks for your response, they do have viewer access. I just enabled 'Make it Discoverable' and it did not help. my question is they can see some data sets even though they are not checked as 'Make it Discoverable'.

what I did was increase the user permission to contributor from viewer and it worked. But that is too much permission to give an end user.