Is something build into Power BI to "copy" daily data into something similiar to a "times series"?

[PeRich]

Hi everybody,

assume, you have a data source http://webserver/todays-data.csv

Is there something build into Power BI to "copy" daily data into something similiar to a "times series (table)"?

If not, how would you do it (automatically)? (Just a couple of Kilobyte each day)

How could it be automated e.g. with Office 365 Tools like Power Automate?

Best regards

[PeRich]

I tried it this way. It should work but I can see only the last date and not the last days.

I think it's my fault.

[v-easonf-msft]

Hi, @PeRich 

Not very clear.

Maybe you need a folder to store each updated version of the csv file.
Then consider import metadata and links about file in folder by using  folder connector.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@PeRich , do need incremental using we data source

https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/

or refer this

https://www.fourmoo.com/2020/06/10/how-you-can-incrementally-refresh-any-power-bi-data-source-this-e...