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.
Hello. I have a macro that extract some content form an intranet, but I´m having trouble to implement the same solution using M.
The part of the vba code that matters is:
---------------------
Parameter = "MyParameter"
Url = "MyURL"
With CreateObject("MSXML2.XMLHTTP.6.0")
.Open "POST", Url, False
.setRequestHeader "User-Agent", "mozilla/4.0 (compatible; MSIE 6.0)"
.setRequestHeader "Content-Type", "application/x-www-form-urlencoded;charset=iso-8859-1"
.send Parameter
txt = .responsetext
End With
Set objXmlHttp = Nothing
text = Split(txt, Chr(10))
-----------
and then I have the data I need in txt format....
Anyone can help me to get the same data using Power Query?
Hi, did you ever figure out how to POST data using Windows Credentials to an API? GET seems to be supported but not POST. Any help would be appreciated as it's driving me nuts! Regards, Steve
@natolira,
Please take a look at the following similar thread to connect to your API using M language.
https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-Authenticate-to-a-REST-API-with-...
Regards,
Lydia
Lydia, thanks! I´m afraid tis link workd with basic authentication, not with windows authentication, which is my necessity.
@natolira,
You can directly add connection information in Advanced Editor to connect to your API. When using Windows credentials , please verify that you have been granted access with your own user/password combination. There are some samples for your reference.
https://jessedotnet.com/2016/06/24/power-bi-connect-to-your-secure-api/
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/
Regards,
Hello. I have a macro that extract some content form an intranet, but I´m having trouble to implement the same solution using M.
The part of the vba code that matters is:
---------------------
Parameter = "MyParameter"
Url = "MyURL"
With CreateObject("MSXML2.XMLHTTP.6.0")
.Open "POST", Url, False
.setRequestHeader "User-Agent", "mozilla/4.0 (compatible; MSIE 6.0)"
.setRequestHeader "Content-Type", "application/x-www-form-urlencoded;charset=iso-8859-1"
.send Parameter
txt = .responsetext
End With
Set objXmlHttp = Nothing
text = Split(txt, Chr(10))
-----------
and then I have the data I need in txt format....
Anyone can help me to get the same data using Power Query?
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.