Forum Discussion

csolutions's avatar
csolutions
Frequent Visitor
7 years ago

Combine last refresh with new data

I might be over thinking this - or the solution just hasn't occurred to me.    I have a data file that pulls pricing by customer and price type. The pricing is entered daily. The ERP system we're u...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi csolutions,

 

Power BI is a data analysis tool, which means the data should be fresh. There isn't a direct way to save the historic data in Power BI for now. If you disable the refresh of one query in the Desktop, it would be historic in the Desktop. But that's inconvenient. 

I would suggest you create a database to store the data due to the size is quite big. 

 

Best Regards,