Forum Discussion
Solved
Question about data refresh
Hi, I wanted to know if it's possible to refresh the data from a SharePoint list automatically. If I can, how can I do it ? Thanks for your help, Tom Victor
Have you looked into PU HT and Quantite Facturee to ensure that they are filled in and are numeric fields so that your calculated column will perform as necessary? Also, do you NEED it to be a calculated column (i.e. are you using it to filter data later)? A measure may be better here. If the need is there for this to be a column it is best to add them as far upstream as possible (if you can't add it to your source, add in Power Query, if you can't add there then add as a calculated column).
christinepayton
Most Valuable Professional
Most Valuable ProfessionalYes, I have a tutorial on scheduling refresh for SharePoint sources here:
The example is SP file sources, but the same exact thing works for SP list sources because the auth is the same.