Forum Discussion

megerwan's avatar
megerwan
New Member
3 years ago
Solved

how to insert measure values into a table after each refresh (sheduled or not)

hello,    i m getting crazy to find a solution to store datas in my dataset after each sheduled refresh !! for a specific projet, my datasets are changing daily and i have a few  measures that i...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , megerwan 

    If you want to get the measure data in your visual after the dataset refresh.

    If you only need the data , can you accrpt the snap image of the report , not a table.

    If this, you can try to use the "Email Subscription" in the report to send an snap to your email after refreshing the dataset.

    For more information, you can refer to :

    Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

    You can also use Power Automate to refresh the dataset and then you can configuire "export file to PDF" in Power Automate.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
3 years ago

power bi is not a database, it is a modelling and visualisation tool.  Thefore it is not the place to create snapshots of your data because each time the source changes your data will get updated.  

  • megerwan's avatar
    megerwan
    New Member
    3 years ago

    thanks.   yes . i don't want to create data snapshots just  keep some historical data for each dataset. 

    maybe i will have to do that outside of powerbi but it's a pity to have to rebuild a SQL query/logic for the measure/calculated columns i have alraedy in powerbi. 

    thanks for your help