Jobs - prakashmehrotra/livedataset GitHub Wiki

#Jobs A job is what gets your data from the source to your Power BI Dataset, so to push data into Power BI, one has to first create a job.

##Creating a Job One can create a new job by clicking the menu item Job > Add > SQL Server/SQL Database (Other connectivity options have not yet been completed and are expected to be part of future releases). This would open up the job settings form.

The job configuration is a 4 step process: ####Step 1 - Job Details Specify the following settings:

1. A name with which you can easily identify your job in a list of configured jobs
2. The interval in which you need to poll the data source and push updates to Power BI. This can be configured from a few seconds up to 15 minutes (900 seconds)

####Step 2 - Source Details Here you mention details of the source system from where the data needs to be pulled:

1. Server Name - ***.database.windows.net for SQL Azure and the machine name or machine name\instance name for On-Premise SQL Servers
2. The name of the database in which the tables we want to sync are located
3. The name of the user used to connect to the database
4. The password of the database user

After providing the above information, click on the 'Validate Connection' button to make sure that the source can be connected. If the connection is successful, you would see the 'success' message in the status bar.

####Step 3 - Source Datasets Once you have validated the source connection, on this tab are listed all tables that exist in the chosen database. There are 2 options here:

1. Checking the 'Initial Load' box will load ALL DATA from the table at the start of this job for the first time
2. Select tables - You can select one or multiple tables here. For each table you can further select the fields that you would want to sync with Power BI. Note that at present only those tables can be selected that have Change Tracking enabled

####Step 4 - Destination Details This is the final step where you specify details to connect to your Power BI Workspace. The following information needs to be specified:

1. Client ID - This is a unique identifier for your Power BI API application. You can create a client ID for your application by following this process.
2. Name of the Dataset that you want to be created within Power BI
3. User name in whose workspace the data needs to be pushed
4. Password of the configured user

Now click on 'Validate Connection' to make sure that the connection to Power BI is successful.

Finally click on the 'Save' button to create the job.

##Monitoring a Job Once a job is configured, you can start it to begin monitoring data in the source dataset and pushing it to Power BI every so many seconds. You start a job by clicking the 'Start Job' link against the job name in the job list. Once a job starts running, its background is changed to light green color.

For a running job one can see the last polled date and the number of records that have been pushed to Power BI since this job was started.

For some reason if your job fails, its background will change to yellow. You can see more information about the job by right clicking the job and selecting 'Show Error Details'

##Modifying a Job Double clicking a non-running job form the list will open up the Job Settings form. One can also modify a non-running job by selecting Job > Modify from the application menu. The only setting that can be changed is the 'Poll Interval'.

In case you need to make more changes, you should 'Clone' (Job > Clone) the job and make required changes. You can delete the original job after cloning if you no longer need it.