Data refresh returning inconsistent data

[WMB1986]

Hi,

I have created a query in Power Query editor that queries data from a SharePoint list. When I refresh the data manually in Power BI desktop it returns the correct results. When I refresh through Power BI online either manually or through a scheduled auto refresh it returns incorrect data. The list where the data is held is protected by SharePoint permissions and only accessible by users with a certain permission level. Has anyone got any idea as to why this would happen?

[Anonymous · Accepted solution]

Hi @WMB1986 ,

Did my answer help you solve your problem?

If my answer helped you, please mark my answer as a solution. This will be of great help to other users who have similar problems as you.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[WMB1986]

Hi, Yes it did, thank you. Your help was much appreciated.

[Anonymous]

Hi @WMB1986 ,

Thanks for the reply from lbendlin .

Here are some factors that I think may be affecting it:

In Power BI Service, navigate to the dataset settings and check under "Data Source Credentials" that the credentials are correct.

Are you using a gateway to refresh data from a SharePoint list? If so, make sure the gateway is online and configured correctly. The account that the gateway uses to connect to the SharePoint list should also have the required permissions.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin]

Do you use time based filters? Is the service access token generated by a different user?