Forum Discussion

TomVictor's avatar
TomVictor
New Member
1 year ago
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
Need Help
  • audreygerred's avatar
    audreygerred
    1 year ago

    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).

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
1 year ago

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.

  • TomVictor's avatar
    TomVictor
    New Member
    1 year ago

    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]

     

    • audreygerred's avatar
      audreygerred
      Icon for Super User rankSuper User
      1 year ago

      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).