Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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
Great thank you
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
User | Count |
---|---|
134 | |
72 | |
70 | |
55 | |
54 |
User | Count |
---|---|
199 | |
95 | |
63 | |
62 | |
51 |