Forum Discussion
Working With SharePoint List
Unfortunatly powerbi does not support live connection with sharepoint list currently. you can still update your report in real time with power automate flow. this post will help you to create live dataset with sharepoint list which will update in real time when new item is added to you rsharepoint list:
https://analyticpulse.blogspot.com/2024/03/integrating-sharepoint-lists-with-power.html
mark this reply as an answer if this resolves you issue.
If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney
SharePoint doesn't support direct query for Power BI. This is where Microsoft draws the line licensing-wise, my impression is that what they want you to do is make things like this using Dataverse and Power Apps (premium), then direct query that with Power BI instead of squeaking by with SharePoint.