Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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..
You may use Value.Metadata to have a check.
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:
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.
I have the same issue. Following the thread.
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.
FYI, I don't know if this helps, but the URL starts in "https://www.ups.com/email-qvm/download..."
Thank again,
Julien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |