Forum Discussion

ChristerSG's avatar
ChristerSG
New Member
5 years ago
Solved

Use snapshots from dataflow for historical data

Hi,

 

I am fairly new in the Power BI universe, but hopefully this isnt a to stupid question.

 

So, I'm trying to figure out the best way to store information from an API (JSON) that only lists the current count. 

In this case its a license count pr customer, which I also need to save the historical readings for. A timestamp-column to get date readings is also ofcourse in place.

 

I have setup a PPU trail and a connected the workspace to ADLS Gen 2 and the dataflow is generating the snapshots as it should.

I tried connecting to the model.json and tried the directory approach, both which just leaves me with the latest snapshot when I try to use it in a report.


So the question is, is there a (easy) way to utilize all the snapshots generated?

 

Best regard,

Christer

Need Help
  • collinq's avatar
    collinq
    5 years ago

    HI ChristerSG ,

     

    If you are creating snapshots and have a unique name for each, you could have Power BI go out to that location and pull all the files in there (using the folder).  The system will automatically append all of those together.  The key is a unique name for each file in the folder so that it is not just overwriting.  

2 Replies

  • collinq's avatar
    collinq
    Super User
    5 years ago

    HI ChristerSG ,

     

    If you are creating snapshots and have a unique name for each, you could have Power BI go out to that location and pull all the files in there (using the folder).  The system will automatically append all of those together.  The key is a unique name for each file in the folder so that it is not just overwriting.  

  • michaelsh's avatar
    michaelsh
    Kudo Kingpin
    5 years ago

    ChristerSG 

    I am facing a similar issue.

    How did you connect to a ADSL Gen2?

    Do you need ADSL license in Azure beyond PPU?

    How do you connect to the folder that has the snapshots?