Hello, everybody,
I have a problem accessing data with a Python script. The script does not find my dynamically generated path.
I want to read data from a JSON file located in the same folder as my Python script and my pbix file.
Because I don't know the parent folder structure, I want to dynamically create the absolute path to my JSON file in the Python script.
I use the following commands to do this:
#get absolute path from filename
from pathlib import Path
my_path = Path('myfile.json').absolute()
#Open the JSON file
with open(my_path, encoding='utf-8') as file:
json_data = json.load(file)
return json_data['items']
However, I get the following error message during data retrieval.
Details: "ADO.NET: Þγţнόņ šċŗΐþŧ έґяθŗ.
Traceback (most recent call last):
File "PythonScriptWrapper.PY", line 207, in <modules>
etl.main()
File "PythonScriptWrapper.PY", line 42, in main
json_data = self.read_json_file()
File "PythonScriptWrapper.PY", line 61, in read_json_file
with open(str(self.source_path), encoding='utf-8') as file:
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Frank\\\PythonScriptWrapper_2c44fb75-27ca-4cf5-bfba-3a5035f935de\myfile.json
Strange is now: If I save the identical path as string in a variable to test it, the data retrieval works (my_path= 'C:\Users\\Frank\\\Desktop\\myfile.json').
However, as soon as I use the dynamically generated path, the data retrieval fails, even though the paths are completely identical.
Does anyone have a solution to my problem?
Thank you very much for your help.
Regards,
Frank
