cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Python scripting not working after windows upgrade 1903

Since upgrade 1903 python scripting has stopped working and throws the following error:

 

ADO.NET: A problem occurred while processing your Python script. Here are the technical details: El archivo o directorio está dañado o es ilegible

 

(file or directory corrupted)

 

I have tried the same file in a few colleague computers which have not updated and it is working fine.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Regular Visitor

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.

View solution in original post

Highlighted
Community Support
Community Support

Hi @Leiru

 

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. 

 

q3.PNG

 

As the issue is resolved on your side, may I close this thread? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Hi @Leiru

 

In your machine, when you open the report in Power BI desktop, please ensure you set the correct Python directory for Power BI desktop to use. 

q2.PNG

 

If the issue still occurs, please share pbix file if possible. You can upload it to your OneDrive and paste the share link here. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

@v-qiuyu-msft 

 

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"

Highlighted
Regular Visitor

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.

View solution in original post

Highlighted
Community Support
Community Support

Hi @Leiru

 

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. 

 

q3.PNG

 

As the issue is resolved on your side, may I close this thread? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Please close.

It happened in a few laptops when upgrading, we will proceed to wipe Python and Power Bi completely and reinstall in those which fail after upgrading.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors