Forum Discussion
Kudo KingpinAccess to dataflows automatic snapshots
Most Valuable ProfessionalHey michaelsh ,
if you use a dataflow without your own data lake you just have a table at the end. So you have to implement snapshots. For example every load you could add a column "loaddate" that safes the load date. In the table you then would have to only load the snapshot you're interested in.
If you use your own data lake, then you can use all the features of Azure Data Lake Gen 2. But you have to use your data lake at the beginning. You cannot switch now afterwards to your own data lake.
Does that make sense?
Kudo Kingpinselimovd I appreciate you trying to help, Denis.
I think you miss my question.
I do not own a data lake, I do not want to deal with Azure license, just Power BI.
How do I connect to all these "snapshot" tables?
- selimovd
Hey michaelsh ,
by default there are no snapshots in Power BI data flow.
You have to create your data in a corresponding way that you can use that as a snapshot. For example add a column with the load date on a daily basis and then do an incremental refresh in the data flow.
Do you know how I mean?
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi