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.

ivancans's avatar
ivancans
Frequent Visitor
8 years ago

Can't this be done somehow with incrimental refresh?

Lind25's avatar
Lind25
Resolver 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
    Community 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.

    • ivancans's avatar
      ivancans
      Frequent Visitor
      8 years ago

      Thank you for the answer. This is what I will need to do. Have to find a soltution how to automtically export data from google sheets