Forum Discussion
Missing Some Data Importing from SharePoint List
Hi fhobson ,
Thanks for reaching out.
Have you tried refreshing the report to see if it can reconnect to sharepoint again successfully to display all data?
Or you can open a new report to connect to the source to see if the error still exists. If in the new report there's no missing data, it means maybe there're some filters that affect the data appearing.
If you still have doubts, it's good to see some screenshots with issues for reference. Please pay attention to protect data privacy.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi there, yes - I have reconnected the data many times and that has not solved the issue. We have 20-30 other fields that update just fine and are refreshed every 2 hours, but this one field that is the only multiline text field, and only comes through to PowerBI for a few elements.
Below is the Update field in question, you can see for some rows, it pulls the input from MS List just fine, but for others, it does not. The highlighted cells all have recent updated (prior to last refresh), but the data is not pulled over to PowerBI.- lbendlin
Super User
Can you create a view with only that field and see if the data comes through when you connect to the view?
Hi fhobson ,
I noticed that you're having trouble extracting data from multiline text field.
There are some ways to handle this. Please refer to
https://whitepages.bifocal.show/2018/04/power-bi-report-rich-text-sharepoint/
Hope it helps.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
