Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm trying to find a solution to append data to an existing data set. The system I use currently tracks resource data at a point in time. For example the data may look as follows:
Prior Month Data Extract View
Current Month Data Extract View
Because of the nature of a PowerBI refresh, when the data changes in the source, the data from "Prior Month" will be over-written by the data now showing in the "Current Month". Hence PowerBI also shows data as Point in Time. This however is ineffective for reporting.
I'd like to be able to achieve the following:
Proposed Data View
From this point, I can then use DAX/M to achieve what I need. I suppose the question is, can I utilise PowerBI to append data on import for a given table rather than to replace data within the table?
Pls note - I do understand that I can run exports from the system and save them as separate files to achieve this. I'm specifically asking if it's possible to achieve this same result, through a direct connection from Source Application --> PowerBI
Thanks
Kirsty
Solved! Go to Solution.
Hi @KCinMelbourne,
I'm afraid that we may not achieve your requirement directly in Power BI.
For the workaround, you could use Append feature in Power BI Desktop.
It seems that the structure of the table didn't change you can append the table with data for new refresh to the existing table wih data for previous data.
In addition, you could refer to this similar thread which the workaround of MarcelBeug is similar to mine.
Best Regards,
Cherry
Hi @KCinMelbourne,
I'm afraid that we may not achieve your requirement directly in Power BI.
For the workaround, you could use Append feature in Power BI Desktop.
It seems that the structure of the table didn't change you can append the table with data for new refresh to the existing table wih data for previous data.
In addition, you could refer to this similar thread which the workaround of MarcelBeug is similar to mine.
Best Regards,
Cherry
Thanks @v-piga-msft, I thought that was the case but I just like to confirm before building manual work arounds.
Really appreciate your feedback.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |