Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
lukas_al9595
New Member

Automatically refreshing exported data

I am interested in knowing if there is a way to make sure my exported data will automatically update when I refresh my PowerBI file.  I used PowerBI to transform into the data I need but then need to export that data to a csv file and was hoping to see if there is a way to automated the exporting process so everytime I refresh the file the exported version will resave with the most up to date numbers

2 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

Use an R Script step for that in your query.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

v-yuezhe-msft
Employee
Employee

@lukas_al9595,

Please take a look at the following similar thread.

https://community.powerbi.com/t5/Service/Export-to-csv-configuration/m-p/105487#M17311

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Employee
Employee

@lukas_al9595,

Please take a look at the following similar thread.

https://community.powerbi.com/t5/Service/Export-to-csv-configuration/m-p/105487#M17311

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

Use an R Script step for that in your query.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors