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

[admin11]

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#M7167...

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

[Fowmy · Accepted solution]

@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 · Accepted solution]

@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]

@Fowmy 

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

[Fowmy · Accepted solution]

You get the error message in Desktop ass well.