Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Well if you are right, this is indeed the best solution.
Well as I can get the data from my sql source, I will create a scheduled task to extract them every week and store them in another database with a new "week number" column. It is the simpler solution.