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.