Power Query Parameter for Python Script

[Anonymous]

I would like to export the data via python to csv and set the download file as a parameter in Power query.

I set a parameter called Export_destination = C:\Users\Name\Desktop And I write a python script for export as follows,

```

Export_destination = "&Text.From(Export_destination)&"
import pandas as pd
data = pd.DataFrame(dataset)
data.to_csv(r'{Export_destination}\test.csv')

```

However, the script still can not work. Does anyone have a good solution for this question?

[Anonymous]

Hi @Anonymous ,

Could you tell me if @Vera_33 's post helps you? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Vera_33 · Accepted solution]

Hi @Anonymous 

There probably are other ways, one way is to get your final file in another power query step

Export_destination = Export_destination&"\test.csv" //this is power query step

....

import pandas as pd
data = pd.DataFrame(dataset)
data.to_csv(r'"&Export_destination&"')

 or call the parameter in Python, concat your filename directly...actually you can do dateset.to_csv directly...

import pandas as pd
data = pd.DataFrame(dataset)
data.to_csv(r'"&Export_destination&"\test.csv')

[Syndicate_Admin]

why is error display that?