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
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!