In Excel Via Get Data From Power BI Dataset

[gissah]

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 appearing in Excel and not all of them.

[v-luwang-msft]

Hi @gissah ,

You can configure the RLS in Power BI so that they can only see the data within the permissions and not all of the data in the report.

refer:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls 

The current limitations for row-level security on cloud models are as follows:

• If you previously defined roles and rules in the Power BI service, you must re-create them in Power BI Desktop.
• You can define RLS only on the datasets created with Power BI Desktop. If you want to enable RLS for datasets created with Excel, you must convert your files into Power BI Desktop (PBIX) files first. Learn more.
• Service principals cannot be added to an RLS role. Accordingly, RLS won’t be applied for apps using a service principal as the final effective identity.
• Only Import and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model.
• The Test as role/View as role feature doesn't work for DirectQuery models with Single Sign-On (SSO) enabled.

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

Best Regards

Lucien

[gissah]

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

[v-luwang-msft · Accepted solution]

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]

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'.

[gauthamboppana]

@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]

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.