Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Twitter API to Power BI

I'm trying to create an API connection between Twitter and Power BI but I'm having no luck at all.   I only need to pull my own user info and not all users historical data.   I believe I require ...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Anonymous  I see the same error when i re-open that pbix, as I've cancelled the authkey since I've shared this.  Did you go to the Source step and replace the code with yours (keep the "Basic " part)?  Once that is working, you can replace the query part with what you want (q=    ).

 

 

Regards,

Pat

 

Peter_Jeyaraj_I's avatar
Peter_Jeyaraj_I
Helper II
4 years ago

Hi mahoneypat , PhilipTreacy 

Hope you can help. I used your sample file and i am facing the issue while generating the token number. See below.

M-Query

let
// Basic auth
authKey = "Basic ****************************",
url = "https://api-e2e.danfoss.com/oauth2/token",
// bearer token
GetJson = Web.Contents(url,
[
Headers = [#"Authorization"=authKey,
#"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
Content = Text.ToBinary("grant_type=client_credentials")
]
)
in
GetJson

 

Error msg

 

 

 

See the working http from postman

 

 

thanks in advance for your support