How to use Row-Security with SharePoint Online ? (refresh of SharePoint Online list) ?

[shak]

Hi everyone!

I'm new in PowerBI.

What i want to do i use a list where items are created by different users. I would like to show only the ones the users created.

I did that using PowerBI Desktop and as a source the SharePoint List. I applied the necessary roles and it worked.

But now i have a new issue. The list won't refresh since is part of the PowerBI file. Is there a way to have both functionalities ? Row-level security with refresh on SharePoint Online lists?

Thanks a lot!

[Anonymous]

Hi ,

Can you please guide on how you achieved role based secutity for different users with SharePoint online list as data connector?

[v-qiuyu-msft · Accepted solution]

Hi @shak,

After you publish the report to service, you need to go to the Dataset Settings. As it's SharePoint online list data source, it doesn't require any gateway. You can just edit credential for the data source. To refresh the dataset, you can click the Refresh Now or Schedule Refresh.

Best Regards,
Qiuyun Yu

[Greg_Deckler]

Once you publish it to the Service, you should be able to configure a scheduled refresh for your dataset so that your Power BI data will refresh from your SharePoint Online list data.