cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
juliensirop Frequent Visitor
Frequent Visitor

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
juliensirop Frequent Visitor
Frequent Visitor

How to Query to an hyperlink which is not a Website

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 Frequent Visitor
Frequent Visitor

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

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

 

Thank again,

Julien

Community Support Team
Community Support Team

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

@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.
juliensirop Frequent Visitor
Frequent Visitor

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

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

fenixen Regular Visitor
Regular Visitor

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

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
Mr_Glister Regular Visitor
Regular Visitor

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

I have the same issue. Following the thread. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 375 members 3,113 guests
Please welcome our newest community members: