Forum Discussion

Chee's avatar
Chee
Regular Visitor
3 years ago

Automate Data Export from Dataflow into Sharepoint folder

Hi All, 

 

I have create dataflow that connect to the sql database to pull the data. Apparently the data in sql database is the snapshot data and was refresh every day. As there are some limitations which the historical snapshot view could not be saved and recreate at the database level. May I know if there any way to automatic export the data from dataflow every monday of the week to get the historical snapshot data ?

 

thanks for help.

Dataflow
Need Help

1 Reply

  • collinq's avatar
    collinq
    Super User
    3 years ago

    Hi Chee ,

     

    There is not an automatic way to do this within Power BI itself.  I guess, if the data is small enough, you could set a subscription that emails the result set, but that wouldn't really be a "data set" per se.

    If you use Power Automate I think you could create this though.