Forum

Turning off Backgro...
 
Notifications
Clear all

Turning off Background data > encounter unexpected error

4 Posts
2 Users
0 Reactions
228 Views
(@bluesky63)
Posts: 162
Estimable Member
Topic starter
 

Hi Mynda,

you had suggested to deselect 'Allow data preview to download in the background' in another threads and most of the users experience great improvement in running their queries

however I had tried to deselect it but encounter  "Unexpected error" Evaluation was canceled"  Retry,   I had clicked Retry several times but still cannot

you advice please

 

thank you!

 
Posted : 13/05/2020 3:27 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Chris, 

Please see this post which explains that this error should be cosmetic. You should be able to refresh them individually. Hope that helps.

Mynda

 
Posted : 13/05/2020 7:21 am
(@bluesky63)
Posts: 162
Estimable Member
Topic starter
 

Hi Mynda,

now I can't even see the UI in Power Query Editor when I click any query trying to edit in PQE,   it shows Send Frown/OK and stay white screen in the PQE,  the workaround now is to click on each query and goto Adv Editor to amend M Code then close and load and refresh in Natvie excel

how to reinstate back to original 

 

Thank you !

 
Posted : 14/05/2020 2:10 am
(@bluesky63)
Posts: 162
Estimable Member
Topic starter
 

Hi Mynda,

I managed to fix it

somehow Power query trying to access a user.zip, temp.zip in my power query directory,  keep on saying is denied,  once I moved out these zip files to elsewhere,  the UI resumed

 

Thank you !

 
Posted : 14/05/2020 2:18 am
Share: