Connect an Analytics for JustFood Power BI template with a JustFood Database

Before you can use the Analytics for JustFood Power BI templates, you must connect the templates with a JustFood database.

Prerequisites

Permissions have been established. For more information, see Establish Permissions for Analytics for JustFood.

To connect an Analytics for JustFood Power BI template with a JustFood database

  1. Open the Power BI Desktop software, and then log in to your Power BI account.

  2. The OData URL from JustFood is used to connect Power BI with your database. To copy the OData URL from JustFood, perform the following steps:

    1. Open JustFood.

    2. Choose Magnifying glass that opens the Tell Me feature, enter web services, and then choose the related link.

    3. Search for ibbi.

      A list of web services where the Object Name starts with IBBI are displayed.

    4. Under the OData URL heading, right-click a value, and then choose Copy Link.

  3. Open an Analytics for JustFood template.

    A dialog box appears that prompts you to enter the OData URL.

  4. Paste the OData URL that you copied from JustFood.

  5. At the end of the URL, delete the information that identifies the web service.

    For example, if the URL that was pasted was:

    http://amurphy-e560.axentia.ca:7048/DynamicsNAV100/OData/Company('JustFood%20Company') /IBBI_Production_Forecast_Entry

    You must remove IBBI_Production_Forecast_Entry so that the OData URL appears as follows:

    http://amurphy-e560.axentia.ca:7048/DynamicsNAV100/OData/Company('JustFood%20Company')/

  6. In the HistoryToCurrentCutoffDate field, enter the starting date for the refresh.

    Note

    The date that is entered here reflects the historical data cut-off date and everything after this date is considered current. For example, if the data in the database goes back to 01/01/2013, and 01/01/2018 is entered, all data before 01/01/2018 is considered historical and all data after 01/01/2018 is considered current. For more information, see History and Current Data.

  7. Choose Load.

    Power BI attempts to connect to your JustFood database. It may take some time as the application loads the data.

  8. If a window opens for ArcGIS Maps for Power BI, choose OK.

  9. If the message There are pending changes in your queries that haven’t been applied. is displayed, to reload the data, choose Apply Changes.

See Also

Analytics for JustFood Setup