Connecting powerbi to a .jsp report

[Riyo_23]

Hi everyone,

I am trying to build a powerbi dashboard. The datasource is a govt .jsp report that's updated monthly. To extract the report we need to enter the item numbers and then click on create report. The source code doesn't point to any master source. is there a way to connect to it and schedule an auto refresh?

Here is the datasource http://medicarestatistics.humanservices.gov.au/statistics/mbs_item.jsp

[Riyo_23]

Great thank you 

[v-cgao-msft · Accepted solution]

Hi @Riyo_23 ,

It seems that parameter changes react in the URL, try using RelativePath to attach these queries:
Web.Contents - PowerQuery M | Microsoft Learn
Chris Webb's BI Blog: Handling Multiple URL Query Parameters With The Same Name Using Web.Contents I...
like:

= Web.Contents(
    "http://medicarestatistics.humanservices.gov.au/statistics/do.jsp",
    [
        Query=
        [
            _PROGRAM="/statistics/mbs_item_standard_report",
            DRILL="ag",
            group={"65175","65132"},
            VAR="services",
            STAT="count",
            RPT_FMT="by time period and state",
            PTYPE="finyear",
            START_DT="202207",
            END_DT="202306"
        ]
    ]
)

Please replace some of the values above with actual values.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Riyo_23]

Hi @v-cgao-msft . How did you extract table from html? I am stuck at this step as I am unable to figure that out. I am fairly new to powerbi. Thanks a lot