Forum Discussion
Limit import based on date
I am importing two Excel spreadsheets into Power BI Desktop. Currently, I am merging one that is a rolling set of data that refreshed every morning and contains 31 previous days into a sheet that is ...
Hi Anonymous ,
It is not available to import rolling data within Power BI Desktop. I would suggest publishing your report and looking into setting up a scheduled refresh. Then your data will be imported automatically.
Check out the following link for more information on data refresh:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.