PBI Extension Documentation for Magento 1

Scheduled updates

 As you may see on the Image 6, there is a separate section called “BIM Power BI Scheduler” in System Configuration.

 

Power BI Integration configuration

Image 6. Power BI Integration configuration.

 

This section allows users to configure:

  1. Regular Load to Power BI.

  2. Live Load to Power BI.

  3. Lifetime Magento Statistics Refreshing

  4. Refreshing of Magento Statistics for the Last Day

Below you will find details about each of the listed items.

Regular Load to Power BI

Regular load is a scheduled data update performed on a daily, weekly or monthly basis. To enable this kind of update, set “Enable Regular Load to Power BI” to “Yes”.

Once the Regular Load option is enabled, you can set Regular Load Frequency and when to start the loading of the data. Usually users may want to set this time to a period with lowest activity, at night.

With Regular Load you may update Load Profiles what contain statistics for long periods of time such as months or years.

Live Load to Power BI

Live load is a scheduled data update performed several times within the day. To enable this kind of update, set “Enable Live Load to Power BI” to “Yes”.

Once the Live Load option is enabled, you can set Live Load Frequency. Allowed options are periods of 1 minute, 2, 3, 5, 10, 15, 30, 60 or 120 minutes.

Lifetime Magento Statistics Refreshing

By setting the option “Refresh Lifetime Magento Statistics” you may activate automated actualization of the Magento Statistics. It is especially important if your Load Profiles relay data from on Magento Reports.

Available options are:

  • No scheduled statistics updates.

Magento statistics will not be refreshed.

 

  • Update before every Live and Regular Loads.

Refresh of Lifetime Magento will be triggered before every Live and Regular Loads.

 

  • Update before every Regular Load.

This is the recommended option.

 

  • Update by separate schedule.

This option allows to enter additional parameter to setup Cron Expression for updating Lifetime statistics independently from loading of the data into Power BI Service.



Refreshing of Magento Statistics for the Last Day

This option “Refresh Magento Statistics for the Last Day” is similar to previous one, but it will trigger only refresh of the statistics for the last day. This option is more preferable to be used in connection with Live data updates.

The options are the same as for “Refresh Lifetime Magento Statistics”. But in this case the recommended option would be

  • Update before every Live and Regular Loads.