Passing Parameter via API for Power BI Reporting

[AR001]

Hi there

I am using the Py script outlined in the wiki page (https://wiki.hornbill.com/index.php/PowerBI_Reporting#Overview_2) to run a report via an API call, save the csv output into a python dataframe, and then load that into a SQL table

This works successfully.

Now I want to pass a Date parameter to my Hornbill report. How should this be configured on Service Manager? The options I see are

[Victor]

On 08/07/2024 at 15:15, AR001 said:

Now I want to pass a Date parameter to my Hornbill report

@AR001 not possible.

EDIT: I stand corrected, see the reply further below.

[AR001]

On 10/07/2024 at 15:03, Victor said:

@AR001 not possible.

Hmm, is this a feature that is due to be added? It is almost impossible to reliably pull data without being able to pass in a parametrised from date. Currently we need to pass in "since start of day/week/month/qtr", but all of that is unreliable if the pull job has failed since before that start date.

[Victor]

5 hours ago, AR001 said:

Hmm, is this a feature that is due to be added?

Development is generally aware of these forum posts, but I have not seen this being considered at this moment in time.

EDIT: I stand corrected, see the reply below.

[Steve G]

HI @AR001,

As long as you have the report set to filter by a user-prompted date input like this:

Then you can pass that input parameter to the reportRun API as so:

reportJson = {
    "reportId": reportId,
    "runtimeParameter": {
        "inputParameter": [
          {
            "uiid": "dt", 
            "inputValue": [
              "2024-07-02 23:00:00"
            ]
          }
        ]
    },
}
reportDetails = invokeXmlmc('reporting', 'reportRun', reportJson)

See the runtimeParameter input in the reporting:reportRun API documentation for more information.

Hope this helps,

Steve