Downloading CSV data via API

[Kasia_]

Hi,
I am struggling with a data loading issue and I have no idea how to fix it. I hope someone here will be able to help me.

Since the beginning of this year, we have been using a new system that was written specifically for us. I received an API from the IT team that downloads data in CSV format. Everything has been working fine so far, but a few days ago, one table stopped refreshing and showed a data authentication error. The IT department informed me that the data loading time had been exceeded and that I needed to limit the amount of data.

Previously, my code looked like this

= Csv.Document(Web.Contents("https://xxx.com/api/v1/sales-invoices/csv?ApiKey=XXXXX"),[Delimiter="|", Columns=21, Encoding=65001, QuoteStyle=QuoteStyle.Csv])

and IT suggested this solution

= Csv.Document(Web.Contents("https://xxx.com/api/v1/sales-invoices/csv?ApiKey=XXXXX&modifiedSince=2025-07-01T00:00:00"),[Delimiter="|", Columns=21, Encoding=65001, QuoteStyle=QuoteStyle.Csv])

The problem with data certification has indeed disappeared, but I need historical data and cannot limit it to a fixed date.
Do you have any solution to this problem?

Thank you in advance for your help!

[v-achippa]

Hi @Kasia_,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin and @ibarrau for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Kasia_,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Kasia_,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[ibarrau]

Hi. You could workout a strategy for building historical data. You can work locally or with a storage. Make sure you export the csv every day or month and make sure you store the data. That way you can later combine them all.

If you have a pbix file with the historical data. You could copy and paste or export that historical data and start taking "since" that last date. Combine them and you could see all data and query reduced rows to the api. You might need a strategy for that. Otherwise it's like Ibendlin says, talk with IT to manage a strategy together for incremental refresh.

I hope that helps,

[lbendlin · Accepted solution]

Ask your IT department to modify the API so that you can also specify  both FROM and TO dates. Also, "Modified Since"  is not helping you if you want to implement incremental refresh, for example. So the FROM/TO range should be for Created, not for Modified.