Forum Discussion

pthapa's avatar
pthapa
Icon for Post Patron rankPost Patron
2 years ago
Solved

How can I keep historical data in Power BI?

Hello Experts, What is the best way to keep the historical data in PBI? It seems like incremental refresh in PBI might do the job however, wanted to check with all experts in PBI. Is there other b...
Need Help
  • collinq's avatar
    collinq
    2 years ago

    Hey pthapa ,

     

    Based on your response, incremental refresh will probably be the best option.  You can use incremental refresh on any date/time field.  Just be sure to understand the "policy" part of the incremental refresh to make sure it is getting the right time period.

collinq's avatar
collinq
Icon for Super User rankSuper User
2 years ago

Hey pthapa ,

 

Based on your response, incremental refresh will probably be the best option.  You can use incremental refresh on any date/time field.  Just be sure to understand the "policy" part of the incremental refresh to make sure it is getting the right time period.

pthapa's avatar
pthapa
Icon for Post Patron rankPost Patron
2 years ago

Any idea why I am getting 'A cyclic reference was encountered during evaluation' upon applying filter on datetime field with RangeStart and RangeEnd parameter in PBI?

Source of my data is sql server and using stored procedure.

thanks,

pthapa