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

[Anonymous]

We have a Sharepoint Online List ... Using Import ...   I have recieved a request to see whehter I can query it live/ Direct so they do not have to wait for updates ...

Also How can I setup the credentails to use the Consumer of the Report on The Service ?  Using Right now Microfost Account ( 0365 )  , then Privacy Organziation on Desktop and Service ... I am currently configured to see all the records..

Thanks for any hints ...

Kathy

[v-juanli-msft · Accepted solution]

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.

[v-juanli-msft · Accepted solution]

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

[v-juanli-msft · Accepted solution]

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.