Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Working With SharePoint List

I have a data model that is connected to various sources including several sharepoint lists that contain transactional data that users update when changes are made.  These changes need to be reflecte...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I am going to try that,  do you know if I can then use that live data in the data model?  For instance as the data is changed/updated in the sharepoint list it needs to be reflected in the model. I have not worked with live query  and import yet. 

AnalyticPulse's avatar
AnalyticPulse
Solution Sage
2 years ago

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