Forum Discussion

ivancans's avatar
ivancans
Frequent Visitor
8 years ago
Solved

Append data from file for yesterday

Hi,   Please help me with the following issue: I have a query to which I need to append a file(published Google sheets file but maybe  it doesn't actually matter what the format is, I guess). When...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I agree with Lind25 that using incremental refresh for this would be a dicey proposition. I would think that the better way to solve this would be to implement a process that downloads the information each day to a file and use a Folder query.

Lind25's avatar
Lind25
Icon for Resolver I rankResolver I
8 years ago

This is not possible in Power BI alone. You will need to use something to store the historic data, eg SQL server.

  • ivancans's avatar
    ivancans
    Frequent Visitor
    8 years ago

    Can't this be done somehow with incrimental refresh?

    • Lind25's avatar
      Lind25
      Icon for Resolver I rankResolver I
      8 years ago

      Incremental refersh is only available in Power BI Premium. It may be technically possible (I do not have access Premium) but it is not designed for this type of use and will cause issues that cannot be resolved if there are ever any issues loading data.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        8 years ago

        I agree with Lind25 that using incremental refresh for this would be a dicey proposition. I would think that the better way to solve this would be to implement a process that downloads the information each day to a file and use a Folder query.