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
- Name, Employment Status, Role Title
- Joe Smith, Contractor, Project Manager
- Samantha White, Employee, Project Manager
Current Month Data Extract View
- Name, Employment Status, Role Title
- Joe Smith, Employee, Project Manager
- Samantha White, Employee, Senior Project Manager
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
- Extracte Date, Name, Employment Status, Role Title
- 1/1/18, Joe Smith, Contractor, Project Manager
- 1/1/18, Samantha White, Employee, Project Manager
- 1/2/18, Joe Smith, Employee, Project Manager
- 1/2/18, Samantha White, Employee, Senior Project Manager
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
