Full refresh and incremental job: A full refresh is a combination of two jobs: ArmaninoDW_PROD and ArmaninoDW_PROD_Incremental.
Parameter passing: The ArmaninoDW_PROD job is responsible for passing parameters to the second job, ArmaninoDW_PROD_Incremental job for it to run as full refresh. The parameters determine whether the job will run as a full or an incremental refresh.
Parameterized scripts: The incremental job has parameterized scripts that can run either as full or as an incremental refresh, depending on the parameters passed by the first job. A full refresh loads all the data from the source, while an incremental refreshed only loads the data that has changed since the last refresh.
Run times: To examine run times of the jobs.
Full Refresh = ArmaninoDW_PROD + ArmaninoDW_PROD_Incremental
Incremental = ArmaninoDW_PROD_Incremental.
Server: 20.25.216.138
Job Names:
ArmaninoDW_PROD
ArmaninoDW_PROD_Incremental
Job created by Kyle Masterson
When a user informs Power BI is not refreshed. Do the following steps.
Go the server 20.25.216.138 and check the “ArmaninoDW_Prod_Incremental” job history in SQL Server management studio.
Check the Export process: “ADW_Entity_Staging” batch job history
Below highlighted dates shows when this report was refreshed.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article