Forum Discussion
How do I delete items from feeder table without deleting from master in PQ editor?
Hello all, I am developing a report that will refresh monthly from a csv file. Each month a new csv with the previous months data will feed into this. Therefore, the mechanism is to load the data...
Hi,
I can confirm the answer from our super users. You're trying to process something, which Power BI can't do: persist data. However, you can create incremental refresh or you process each time everything each reload. As you have monthly data, this would be the better option, as I think that you won't have much of data amount issue, moreover a reloading time, which isn't that bad thinking of having monthly refreshes.
Another option would be, can you implement this in another source system like SQL and SSIS, Azure SQL DB or Fabric?
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.