Forum Discussion
Compiled Daily Data Snapshot with Date When Date Was Collected in SQL
Hi everybody, Is there a way in Power Query wherein I can get the data in SQL once a day and add a column in Power Query to show when that data was collected. Then append that data to the data...
Hi, unfortunately this is not supported by Power BI.
You can do this online in Fabric (but you need Fabric Licence) https://www.youtube.com/watch?v=E5axX6auBN4&ab_channel=AmitChandakLearnMicrosoftFabric%2CPowerBI%2CSQL or
https://www.youtube.com/watch?v=xzhmaQnB2fM&ab_channel=AmitChandakLearnMicrosoftFabric%2CPowerBI%2CSQL.
I also saw some posts that you could managed this with incremental refresh, however this solution is very unstable. I think here they discuss it: https://community.fabric.microsoft.com/t5/Service/Data-snapshot-using-Power-BI-Incremental-refresh/m-p/2684063
Kudos appreciated 🙂