Why refresh at location A okay but refresh at location B not okay ? all my raw data store at sharepo

[admin11]

Hi All

I have PBI file , which is running fine for 2 yr , last week it take me 3 day with sleepless night to solve the issue , 

@mahoneypat help me with below post :-

https://community.powerbi.com/t5/Desktop/My-PBI-unable-refresh-what-else-I-should-try/td-p/2376951

I was happy for 2 days , and i am able to refresh at my house and my mother house , but now the issue happen again. 

Again i check it is cause by CRM table error , when i delete the CRM table at PQ editor , it work fine. 

My question is why refresh at my mother house work fine , and refresh at my house not work fine ?

Paul Yeo

[v-jayw-msft · Accepted solution]

Hi @admin11 ,

Where is this CRM table stored? This situation may be caused by the change of network environment which makes some paths become not access anymore.

Best Regards,

Jay

[admin11]

@v-jayw-msft 

Some how i found the issue is cause by CRM data file , which is i manually copy the CRM CSV file to sharepoint , that CRM file data format have change from ZOHO CRM , which i not aware . As i never expect that file format change. 

Paul