what is the faster way to prevent loading GL table ? since it get error msg ?

[admin11]

Hi All

My 3th day unable to refresh . check all sharepoint folder it seen that nothing wrong , except one of the folder for GL table now it appear the error msg :-

My approach is :-

(1) To remove the GL Table from loading.

In order to remove GL Table from loading , so that i can solve the load problem. that is my top poirity now. 

Below is GL Table Loading :-

1. i load the GL Table from Coy A and Load GL Table Coy B , and i append Coy B into Coy A.

To make refresh error can be disappear. i have 2 option  delete or disable the loading ?

I have try to set to disable from Enable loading :-

Can i confirm if i refresh  still have error , does it mean the error is come from other table ?

Thank you 

Paul 

[V-lianl-msft]

Hi @admin11 ,

Have you refreshed your model after the table was deleted and apply it? If yes, then this error should not pop up. If it still persists, go and delete the temp files from the below path:

C:\Users\XXXX\AppData\Local\Microsoft\Power BI Desktop\TempSaves. This would not impact any of your data and files, it would just clear the temp files that is being cached.

Another possibility is whether you have referenced the deleted table in the measure or calculated column? This may also cause refresh error in the desktop

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@admin11 , Once you disable loading the table should not show in Data View.

If the source are not correct then correct the source.

Or add the tables again as a new table. Copy the code from the advance editor and paste it into old tables

refer

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0