Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
hi guys,
Im using power query to use shipment data using the tracker from various shipping sites. Im having trouble with UPS as the HTLM viewer doesnt seem to view the table with actual shipment data
heres an example using the standard ups tracking site
M Code
let
Source = Web.BrowserContents("https://www.ups.com/track?loc=null&tracknum=[insert tracking number here]&requester=WT/trackdetails"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR > :nth-child(1)"}, {"Column2", "DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR > :nth-child(2)"}}, [RowSelector="DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR"])
in
#"Extracted Table From Html"
the same adresss does show more detailed data like date of shipment and recived date(as Shown below) , yet i cant get the viewer(html) to view
any ideas on what may be causing issue
Solved! Go to Solution.
NVM fixed using the HTML viewer, thanks for the help
It sounds like you don't actually have a Power Query issue but need help displaying the result as SVG, is that correct?
Not sure what you mean by SVG,but yes what i need is a way to get the date information (picture below)
if posible this part as well
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |