cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

6 REPLIES 6
Highlighted
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.

Highlighted
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

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

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

Highlighted

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

Highlighted

I have the same issue. Following the thread. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors