Forum Discussion
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).
4 Replies
Hi! Do you mean you want Power BI to update everytime there is a new record in a Sharepoint list, on an automated schedule, or something else? If you want it on a schedule, you can set this up in service. If you have premium capacity you can do up to 48x a day. If you have Pro plan, you can set up 8. If you want it to refresh everytime a new record is added to SharePoint List, you can accomplish that by setting up a flow in Power Automate.
Hi !
Thanks for your reply, I tried to schedule a refresh and it seems to have an issue when I'm refreshing the data.
I have this message :
" The query has referenced the calculated column '<oii>IX-Facturation</oii>'[<oii>Montant facturé</oii>] which contains no data, as the evaluation of one of the rows has caused an error.
Try again later or contact support. If you contact support, please provide this information. "I used a formula for "Montant facturé" who is :
Montant facturé = 'IX-Facturation'[PU HT]*'IX-Facturation'[Quantité Facturée]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).
Yes, 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.
