Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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.
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
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.
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"
Hi @Anonymous,
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |