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.
In SPO lists or document libaries you can edit the properties on an item and enter notes. Multiple notes can be entered over time.
When I look at the data brought back by PowerBI it only shows the most recent note in the Notes1 field.
Is there a way to get the full notes history, is it a child table I need to expand somewhere?
Thanks!
Based on my test, the built-in SharePoint connectors in Power BI Desktop don't contain the full notes history, as your post, it is possible to show the most recent note.
To show the full history of an item, please check these workarounds which are discussed in the similar thread below.
https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-...
Regards,
Lydia
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.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |