The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am running a simple scrpit in the power query editor as noted below it works really well the only thing I have noticed is that it will create the file, if not already created with the same table information listed three times. Then if I refresh the data it will append the information to what is there already but again adds the new information to the bottom three times. Is this because the script is ran three times during the refresh stage or is it something to do with the script?
write.table(dataset, file = 'filepath.filename.csv', sep=',', append=true)
Thank you in advance for your help.
mbrightman
Solved! Go to Solution.
If that query is referenced in other queries, please see this blog/video for an explanation.
Chris Webb's BI Blog: Why Does Power BI Query My Data Source More Than Once? (crossjoin.co.uk)
Pat
If that query is referenced in other queries, please see this blog/video for an explanation.
Chris Webb's BI Blog: Why Does Power BI Query My Data Source More Than Once? (crossjoin.co.uk)
Pat