Forum Discussion
Python scripting not working after windows upgrade 1903
UPDATE:
Deleted Python, PIP, supressed manually all the folders. Same thing for powerBI, deleted al Windows.old files, cleaned previous windows installs. Reinstalled everything....and now seems to be working.
Hi Anonymous,
I tested on my side with your sample script, it returns a table as expected. It seems the issue is related to a specific machine not windows update.
As the issue is resolved on your side, may I close this thread?
Best Regards,
Qiuyun Yu
I had already tried wiping the python install, reinstaling python3 also python2 and still the same error. I was just using the scripts with no errors, the windows upgraded and now no Python scripts work.
I am copying the code of the query. I just create an empty table to pass a value to the script, create a timestamp and then return it in a table. No matter what I input in any script it just breaks.
let
//table creation for running python timestamp script.
URLtable = #table({ "expirationTime"}, {{"0"}}),
#"Run Python script" = Python.Execute("# 'dataset' holds the input data for this script#(lf)import hashlib#(lf)import time#(lf)#(lf)#create date token#(lf)millis = int(round(time.time() * 1000))#(lf)millis = millis + 1800000#(lf)#(lf)dataset.at[0,'expirationTime'] = millis#(lf)",[dataset=URLtable]),
#"Expanded Value" = Table.ExpandTableColumn(#"Run Python script", "Value", {"expirationTime"}, {"Value.expirationTime"})
in
#"Expanded Value"