Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.