No announcements
Found 163858 threads
-
0 VotesWeb.Contents with No Authorization header
The fact that Power BI doesn't send an Authorization header but VS does makes me wonder if it's due to a difference in the creds you have configured for the data source in each ...Answered | 2 Replies | 564 Views | Created by Paulo Vasconcellos - Wednesday, April 1, 2020 10:29 PM | Last reply by Ehren - MSFT - Wednesday, April 15, 2020 8:50 PM
-
0 Votes
Web.Contents()
s=web.contents Many thanks.Answered | 1 Replies | 739 Views | Created by P_a_u_l_c - Wednesday, January 11, 2017 9:35 PM | Last reply by Nin Sute - Wednesday, January 11, 2017 10:39 PM -
8 Votes
Power Query - How to format options for Web.Content()?
If you are using Basic authentication, the correct "Authorization" header is the base64-encoded version of "username:password", so the ...Answered | 16 Replies | 27040 Views | Created by Daniel Wikar - Saturday, November 2, 2013 8:34 AM | Last reply by JulianPayne1 - Friday, October 19, 2018 6:02 PM -
2 Votes
How to ignore Web.Contents error on Power Query
I am trying the following for digest authntification: let Source = Web.Contents(URL, ...Answered | 9 Replies | 5747 Views | Created by Yoshihiro Kawabata - Wednesday, September 4, 2013 6:56 AM | Last reply by SFBloo - Tuesday, October 31, 2017 6:54 PM -
2 Votes
Web.Contents Query
let Source = Web.Page(Web.Contents("games.espn.com/ffl/leaders?Answered | 3 Replies | 1240 Views | Created by TheGreatestAjax - Monday, December 12, 2016 5:21 AM | Last reply by Imke Feldmann - Wednesday, December 14, 2016 8:14 AM -
2 Votes
Can't pass "Authorization: Bearer" header using Power Query
let Custom1 = (Web.Contents("http://open.mapquestapi.com/geocoding/v1/address", [Query= [#"key"="<<masked for ...Answered | 2 Replies | 2135 Views | Created by steven.buehler - Monday, February 29, 2016 8:12 PM | Last reply by Curt Hagenlocher - Wednesday, March 2, 2016 3:14 PM -
0 Votes
Bug in Excel.Workbook(Web.Contents()) PowerQuery
let Source = ...Answered | 7 Replies | 1970 Views | Created by Tom2019_200 - Tuesday, April 21, 2020 11:36 PM | Last reply by Imke Feldmann - Monday, June 15, 2020 8:58 AM -
0 Votes
Can I change UserAgent at Web.Contents() ?
Can I change UserAgent at Web.Contents() ?Answered | 1 Replies | 2866 Views | Created by Yoshihiro Kawabata - Tuesday, September 17, 2013 4:04 AM | Last reply by Miguel.Llopis - Saturday, September 21, 2013 12:50 AM -
0 Votes
UAG stripping authorization header
I published a RESTful AJAX app that uses a custom authorization scheme and enabled SSO.Answered | 2 Replies | 6101 Views | Created by Bryan2012 - Monday, June 11, 2012 7:39 PM | Last reply by Bryan2012 - Wednesday, June 13, 2012 5:06 PM -
0 Votes
Power Query - Zendesk API - Scheduled Refresh - Dynamic Web.Contents
let Source = Web.Contents("https://INSERTHERE.com/api", [RelativePath=URL]) in Source in WebCallAnswered | 6 Replies | 1204 Views | Created by naelske - Monday, December 16, 2019 2:03 PM | Last reply by Ehren - MSFT - Monday, January 6, 2020 8:26 PM -
2 Votes
Power Query executing web.Contents query twice - How to stop?
It seems the problem is Web.Contents itself.Answered | 5 Replies | 3400 Views | Created by RandWro - Tuesday, July 21, 2015 1:20 AM | Last reply by BennieLhere - Saturday, April 13, 2019 10:03 PM -
3 Votes
Why does the web.contents make multiple requests?
One way you may be able do this is by placing an Text.FromBinary call in between Web.Page and Web.Contents: = ...Answered | 3 Replies | 962 Views | Created by Simon Sabin - Monday, May 4, 2015 8:12 PM | Last reply by Tristan St-Cyr - Tuesday, May 5, 2015 8:17 PM -
0 Votes
Web.Contents 403 error handling
Web.Contents(APICall, [ManualStatusHandling={403}]), #duration(0,0,0,0.5)), APIData3 = Function.InvokeAfter( () => Web.Contents(APICall), ...Answered | 1 Replies | 1942 Views | Created by Texas Ed - Wednesday, December 20, 2017 5:15 PM | Last reply by Ehren - MSFT - Wednesday, January 10, 2018 6:35 PM -
2 Votes
OData.Feed and custom HTTP Headers
The authentication mechanism is based on OAuth2, but once I have received my token I have to pass it back to the API via the Authorization header.Answered | 5 Replies | 7983 Views | Created by JurgenPostelmans - Wednesday, November 18, 2015 1:14 AM | Last reply by Christopher Webb - Saturday, January 27, 2018 8:39 PM -
0 Votes
Odd Web.Contents behavior making multiple calls to API based on load time
From what we can tell, when PowerQuery uses Web.Contents to get a JSON packet back, it will cache the dataset internally, if set up correctly.Answered | 5 Replies | 1081 Views | Created by Michael A Boisvert - Friday, April 17, 2020 3:35 PM | Last reply by Ehren - MSFT - Wednesday, May 13, 2020 9:34 PM -
1 Votes
REST API - Basic authentication UI stored in HEADER
Yes, using Basic auth should be equivalent to specifying the headers as you showed above, with the exception that the "username:password" will be base-64 encoded.Answered | 3 Replies | 825 Views | Created by naelske - Thursday, December 19, 2019 10:32 AM | Last reply by Ehren - MSFT - Monday, January 6, 2020 8:32 PM -
0 Votes
With some specific url Web.Content doesn't work
Hello, can someone please explain why only with some URLs like the following, Web.Content function does not work while Web.Browsercontent function do?Answered | 4 Replies | 793 Views | Created by Franco Fornari - Monday, January 27, 2020 10:05 AM | Last reply by Franco Fornari - Tuesday, February 4, 2020 6:40 PM -
1 Votes
Web.Contents function un-encoding '%2F' to a '/' when using GET request
Hi, any help here much appreciated, I'm trying to call a web API with Web.Contents, example power ...Answered | 6 Replies | 2222 Views | Created by Richard_Warriner - Tuesday, July 17, 2018 10:45 AM | Last reply by Ehren - MSFT - Monday, November 12, 2018 6:49 PM -
0 Votes
How to programmatically add HTTP headers along with a URL
I'm successfully retrieving data from a REST API endpoint when I do it manually, but I can't find a way to dynamically change the headers.Answered | 1 Replies | 464 Views | Created by dpiret - Monday, June 19, 2017 8:34 AM | Last reply by Ehren - MSFT - Friday, June 23, 2017 11:33 PM -
4 Votes
trying to pull data from REST api, but getting "The user was not authorized" error
This is my power query: let actualUrl = "removed", options = [Headers ...Answered | 3 Replies | 581 Views | Created by ukeasyproj - Thursday, December 1, 2016 9:01 PM | Last reply by Imke Feldmann - Thursday, December 8, 2016 5:43 PM - Items 1 to 20 of 163858 Next ›
No announcements
