Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

PBI desktop when fail to refresh data , will it provide error cause by which field name ?

Hi All

 

Fowmy  help me a lot by provide me the answer on below post . which is suddenly my web service unable to refresh data. it was lucky that i get error massage from email notification , and state that the error is cause by one of the field name "drawing number" missing. ( The issue is due to file corrupted , after i replace the CSV file , now all runnig well. )

https://community.powerbi.com/t5/Desktop/My-PBI-web-Service-auto-refresh-get-error/m-p/1858075#M716794

My question is , Does PBI desktop , when i reload , does it able to tell me unable to reload data , is cause by which field missing ? 

 

Hope some one can share with me, as i only get below error msg , but does not info me cause by which field name.

 

Paul

  • admin11 

    Power BI will only know if there is a change in the metadata when you load the tables either in Power Query or in the Data Model at the time of refreshing the data. It can be on the Desktop or the Service. Columns used in the calculations will have to be present at the time of refresh.

  • Fowmy's avatar
    Fowmy
    5 years ago

    You get the error message in Desktop ass well. 

3 Replies

  • admin11 

    Power BI will only know if there is a change in the metadata when you load the tables either in Power Query or in the Data Model at the time of refreshing the data. It can be on the Desktop or the Service. Columns used in the calculations will have to be present at the time of refresh.

    • admin11's avatar
      admin11
      Icon for Memorable Member rankMemorable Member

      Fowmy 

      In short only PBI web service will info the error msg like which field is missing right ?

      • Fowmy's avatar
        Fowmy
        Icon for Super User rankSuper User

        You get the error message in Desktop ass well.