Forum Discussion

Salvador's avatar
Salvador
Responsive Resident
9 years ago

Storing and using information from a dynamic data source using PBI desktop.

Hello,   This is something that I've worked in for a couple of months, and have been successfully using it for 3 months, and now would like to share with the community. If you want to know where th...
Show and Tell
Tips and Tricks
Kaeso's avatar
Kaeso
New Member
8 years ago

Quick question.  It looks like the data pull is managed through the task scheduler, what about the combining of files?  Is that a manual process?  Does it need to be done at every refresh to preserve the data creation timestamp?

  • Salvador's avatar
    Salvador
    Responsive Resident
    8 years ago

    Hello Kaeso,

     

    It's explained in the post, you have to use folder as data source for the csv files, so, it will add everything that is in that folder every time it is refreshed :smileyvery-happy:

    Regarding the data timestamp, look for "After that, we will create a column: Data's Date = IF (ISBLANK (FinalData [Refreshment date]); now (); FinalData [Refreshment date])

    That way, we will be able to know when that data was stored." in the post. By creating this on the data that we want to store, when it is stored in a csv, it will take the current time as a timestamp, and every csv created using the script will have it's own timestamp.

     

    If you have any other doubts, dont hesitate to ask :smileyvery-happy:

     

    Regards,

    Salva.

     

    • bsedd's avatar
      bsedd
      Regular Visitor
      7 years ago

      Hi,

       

      I am trying to create trend KPIs from Power Bi and this looks like a potential solution.

       

      The script is currently unavailable, any change of a reupload?