Forum Discussion

juliensirop's avatar
juliensirop
New Member
8 years ago

How to get data from an hyperlink which is not a Web Site

Hi,   I'm getting UPS data by email on daily basis with a link in it. Clicking on the link triggers an Excel Spreadsheet Download, and I would like Power BI to pull this data itself.   I already ...
MmmVvv_23's avatar
MmmVvv_23
Frequent Visitor
2 years ago

Extract URL as first (custom column with a name "URL" in Power Query), in my case I got it in this form:

https://TESTTESTTESTTESTE/?url=https0123456789=0

 and then new custom column form that URL:

 Web.Contents([URL]


This should give you Binary (in my case .csv), depends in which format they are when you click on them.

Afterwards, proceed with ETL..