Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Riyo_23
Frequent Visitor

Connecting powerbi to a .jsp report

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

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
Riyo_23
Frequent Visitor

Great thank you 

v-cgao-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.