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.
Currently have multiple line of text column with "Append Changes to existing text" turned ON in a Sharepoint List.
I created a Power BI report to display information related to the list inclusive of those Multiple text with append changes on columns.
However, when I display the text columns in a table I am not seeing the text stored and only few row with recent changes are imported.
When view the Item in Sharepoint list, the text is there.
How can I get the full text stored in multiple line and display it in Power BI? Screeshot of same is attached.
Thanks for any assistance with this issue.
Hi, I have the same issue with my connection to the SP list. @djrao07 have you managed to find a solution to this problem?
Thanks
Good day, I also have the same issue. Is there a solution as yet?
@djrao07 - Looks like you're in for some work based off https://community.powerbi.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-... .
I'm trying to imagine what you're using this method for, hard to tell with your sample. My guess is some sort of comment log? You can do some pretty nifty things using Power Apps and Power Automate to collect and transform your list. Take a look at https://www.youtube.com/watch?v=GyoD0DD_fW0 by Reza Dorrani. Specifically his 'log history' implementation.
Proud to be a Super User!
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |