Recently one of my Reports has stopped fully pulling information in from a SharePoint online list.
Oddly, it will pull some information in but not everything.
For example, I have 5 records each with 10 columns of information.
I hit refresh.
It pulls in 3 records and not all 5?
Any help would be greatly appreciated.
Go to Solution.
Hi @kelly008 ,
Best Regards,Community Support Team _ Yingjie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Are you using v2 of the SharePoint List connector by chance? It connects to the View infrastructure in Power BI so if someone added a filter to the view, your query will be filtered as well.
Hope this helps!
Treb Gatte, Marquee Insights
@kelly008 , Please open power query and check for any issue
debug issue https://www.youtube.com/watch?v=OE6DPmKqN7srefer how to handle error in power queryhttps://www.youtube.com/watch?v=OE6DPmKqN7shttps://www.youtube.com/watch?v=9-Lag0VOiTs
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.