Forum Discussion

moksha's avatar
moksha
Frequent Visitor
7 years ago

sync power bi table into excel automatically on monthly basis

I have a power bi file that has a table which gets updated monthly with new months data.

I would like to export the data month wise into excel sheets or workbooks on sharepoint whatever possible. Basically sync power bi table with excel on monthly basis keeping the previous data 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi moksha ,

    I still have a little confused about your requirement.

    What's mean of "sync power bi table with excel on monthly basis keeping the previous data "?

    If it is convenient, could you explain it in more details so that we can understand your scenario better?

    Best Regards,

    Cherry

    • moksha's avatar
      moksha
      Frequent Visitor
      7 years ago

       A table keeps data per month , when current month is added the old  month's data gets overwritten. I want to show the old month data and new month data and keep appending it with new month's data.

      Tables are retrieved from odata feed files so there is no way to know the sources of that tables.