Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
5 years ago

Data limit and incremental refresh

Hi,   My data source is web where i need to bring last 1 year data into power bi report. I want to store rows for the last 1 year and refresh the rows for last 15 days based on datetime field.  My...
Need Help
jitpbi's avatar
jitpbi
Post Patron
5 years ago

Thank you ibarrau  for the above explanation.

In addition to my original post, I am getting data through API but the data source is Cosmos DB. This is because some internal guidelines but can be explore to connect directly to cosmos db if required.

so just wanted to understand, is there any workaround possible to store 1 year data if i directly connect to Cosmos DB instead taking it through API?

ibarrau's avatar
ibarrau
Super User
5 years ago

Interesting. I haven't tried cosmos db. You can try the Power Bi connector to get your data. I don't know if you can query it like "last 365 days" or something like that. If you can't, consider filter the last 1 year of data from Power Query (transform data menu) that run before close & apply.

Let's see how that works before considering moving data to a different place.

Regards,