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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
juliensirop
New Member

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 know how to go to me emails and isolate the link, but when I try to do a Web Query to the URL, Power BI returns an error:

 

=Web.Page(Web.Contents("URL"))

The resource at "URL" cannot be retrieved using Web.Page. It doesn't appear to be a web page

 

Is there any Query that returns data from this kind of link?

 

Let me know if you need any additional information.

 

Thanks,

Julien

7 REPLIES 7
MmmVvv_23
Frequent Visitor

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..

v-chuncz-msft
Community Support
Community Support

@juliensirop,

 

You may use Value.Metadata to have a check.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-chuncz-msft,

 

Thank you very much for getting back to me.

 

Could you please explain to me how to use this function in my specific case? I had a look on the internet but couldn't figure out how to use it ... All I can get is this:

 

Power BI Value.Metadata.png

 

Thanks,

Julien

Did you figure it out?  I have the same issue trying to open a csv file from a web page url.. 


I have this URL (requires authentication, but i want to show how the URL looks)   https://"myCompany"/_/service/no.company.placeholder/read-and-acknowledged?id=7fc4c347-a074-44e3-b257-1627d763492c

 

If I openthe URL in Chrome it downloads a .csv file. I cannot figure out why power BI can't do the same? It authenticates just fine, but returns the message cannot be retrieved using web.page. It doesn't appear to be a web page

 

If i change it to .csv i only get this picture, its the code of the page, not the csv file. 

urlwhencsv.jpg

I have the same issue. Following the thread. 

juliensirop
New Member

Hi,

 

I'm getting UPS data by mail on daily basis with a link in it. Clicking on the link triggers automatically an Excel Spreadsheet download, and I would like Power BI to pull this data itself.

 

I know how to go to my emails and isolate the link. My issue is that Power BI returns an error when I try to do a Web Query on this link.

 

=Web.Page(Web.Contents("[URL]"))

"The resource at [URL] cannot be retrieved using Web.Page. It doesn't appear to be a web page."

 

Is there a Query to get data from this kind of link?

 

Let me know if you need any additional information.

 

Thank you very much,

Julien.

juliensirop
New Member

FYI, I don't know if this helps, but the URL starts in "https://www.ups.com/email-qvm/download..."

 

Thank again,

Julien

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.