Forum Discussion
Difference in Data output between service and dekstop
Hello,
Thank you for sharing this. We have tried optimizing and ensuring all Power Query Transformation steps are not the issue.
Id like to provide an update that the issue was resolved with conencting to an On-Prem gateway. this is odd, because all Sharepoint data is cloud based and should not require a gateway, and other repors are working fine without one.
Community SupportHi albarasabbaghh , Thank you for reaching out to the Microsoft Community Forum.
I don’t think this is a credential issue. When Desktop shows full data but Service drops rows after refresh, it usually points to how the SharePoint connector executes in the Service, especially pagination, thresholds or transformations breaking query folding. I also think you should also check for hidden filters or rows erroring out during refresh, as Service can silently exclude those.
Hello,
Thank you for sharing this. We have tried optimizing and ensuring all Power Query Transformation steps are not the issue.
Id like to provide an update that the issue was resolved with conencting to an On-Prem gateway. this is odd, because all Sharepoint data is cloud based and should not require a gateway, and other repors are working fine without one.
- v-hashadapu
Hi ShathaSaleh , Thanks for the update and the information regarding the issue. We are very happy to know the issue is solved. If you have any other issues, please feel free to create new posts here in the community, we are always happy to help.