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

gissah's avatar
gissah
Regular Visitor
4 years ago

I did not try this option, what I did was increase the user permission to contributor from viewer and it worked.

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
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