Forum Discussion
Modeling Data over Time
Have a look at the two example files in this folder.
Example 1 is a very basic example of how your snapshotted SQL table could look with a custom date table related to it in order to enable future analysis.
Example 2 then uses power query to shape the data into a better star schema which will keep the model faster as your data volume grows. This data transformation could be done at source in SQL Server using SSIS for example.
Hope they show how it could look.
Yes totally making sense.
You're worrying to much about duplicate names though. You want the same table structure but with a date column that gets populated when you do the insert. You could then build a clustered key based on date, server and filename.
When you load that into power bi you should then be able to get the information you need. I'll try and mock something up later this evening.
Have a look at the two example files in this folder.
Example 1 is a very basic example of how your snapshotted SQL table could look with a custom date table related to it in order to enable future analysis.
Example 2 then uses power query to shape the data into a better star schema which will keep the model faster as your data volume grows. This data transformation could be done at source in SQL Server using SSIS for example.
Hope they show how it could look.
Thank you very much! That makes a lot of sense. Greatly appreciate your time with this!
