# Generating Power BI Data Source

Open iT can extract the Core Server database into CSV files to be able to load it in Power BI.

# Activating Power BI Data Source Generation

These are the required steps to activate Power BI data source generation.

Open a command prompt with Administrator level privileges.
Go to the bin directory, which is by default in C:\Program Files\OpeniT\Core\bin, run the command:
Command Syntax
```
cd $BIN_DIR
```
Example
```
cd C:\Program Files\OpeniT\Core\bin
```
Once in the directory, activate the data source generation to run daily, run the command:
Command Syntax
```
openit_oconfinit -u "transfer_misc_files.root.scheduler.jobs.transfer_misc_files.general.active=true"
```

Go to the bin directory, which is by default in /opt/openit/bin, run the command:
Command Syntax
```
cd $BIN_DIR
```
Example
```
cd /opt/openit/bin
```

Once in the directory, activate the data source generation to run daily, run the command:

Command Syntax
./openit_oconfinit -u "transfer_misc_files.root.scheduler.jobs.transfer_misc_files.general.active=true"

# Verifying Power BI Data Source Generation

After configuration, you can verify that the Power BI data source is generated by following these steps:

Open a command prompt with Administrator level privileges.
Go to the bin directory, which is by default in C:\Program Files\OpeniT\Core\bin, run the command:
Command Syntax
```
 cd $BIN_DIR
```
Example
```
 cd C:\Program Files\OpeniT\Core\bin
```
Run the command:
Command Syntax
```
 openit_executor -r process_powerbi
```
Verify that there is a folder named powerbi present in $DATA_DIR, which is by default in C:\ProgramData\OpeniT\Data\database, containing the folders of the configured data types.

The output inside the data type directories are in the format year-month-date.csv. There should also be a cache file per data type.

The output files are fixed to a daily resolution, and the delimiter is always colon.

Go to the bin directory, which is by default in /opt/openit/bin, run the command:
Command Syntax
```
 cd $BIN_DIR
```
Example
```
 cd /opt/openit/bin
```
Run the command:
Command Syntax
```
 ./openit_executor -r process_powerbi
```
Verify that there is a folder named powerbi present in your defined $DATA_DIR upon Open iT server installation, containing the folders of the configured data types.

The output inside the data type directories are in the format year-month-date.csv. There should also be a cache file per data type.

The output files are fixed to a daily resolution, and the delimiter is always colon.

The implementation of caching guarantees that no date per data type will be processed more than once. However, this does not guarantee data stability if the server machine shuts down while the tool is running.

To ensure data reliability in such cases, delete the cache file and output file in each data type on the date the server machine shuts down, then restart the server, making sure that the scheduler is active.

The caching implementation not only checks for the cache file, but also for the existence of output files starting from the date as calculated by the value of the POWERBI_CUTOFF_AGE directive.

# Next Step?

Configuring Power BI Cut-off Age and Data Types