Python Script Export TO CSV Runs 3X

[tecumseh]

Hi all,

Using PBID April, 2025

My python script to export the dataframe to csv file runs 3X so I have 3 output files
How can I get the script to execute only 1X?

Thanks,

w

from datetime import datetime as dt 
import pandas as pd 

filename = 'Octillion_Creative' 
filext = '.csv' 

# Get current date and time with microseconds 
current_time = dt.now() 

# Format date and time as string including microseconds 
timestamp = current_time.strftime("%Y%m%d_%H%M%S_%f") 

total_file_name = filename + '_' + timestamp + filext 

output = pd.DataFrame(dataset) 
output.to_csv("fakepath\\" + total_file_name) 

[lbendlin]

Where is that Python script running? In Power Query?  Power Query gives no guarantee whatsoever that it will only run once per refresh.

[tecumseh]

Thanks @lbendlin 

Yes - power query

Thanks

w

[lbendlin · Accepted solution]

https://learn.microsoft.com/en-us/power-query/multiple-queries

https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/

https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/

etc.