Sharepoint Online DataSource can we Live Connect and Use the Consumers Access to the Reporrt

Hi Anonymous 

Direct query/live connection is not supported for sharepoint list with Power BI.

Aslo, there are not different  credentails for different users to consume the reports in Power bI Service.

 

However, there are some workaounds.

1.

Here's a blog post that some wrote that describes the use of a 3rd party tool to synch the SharePoint lists with normalised SQL Azure tables which then gives you the option of direct query.

Since SQList updates SQL Azure as soon as SharePoint changes are made it is a very nice workaround for Direct Query

Power BI direct query workaround for SharePoint

 

2. To make different users see different data based on their account and permission, you could consider RLS.

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

https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

 

 In addition, with importing and configure schedule refresh, it will update on schedule and you can set the frequency on your own.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

 

Best Regards

Maggie