Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I really don't understand how Microsoft and the PowerBI team provided javascript api examples for everything except how to get the access token... I have been at this for a while trying to figure out how to get access to the api. I have the client id for an app. I don't want the users to have to sign in for themselves, I want to use my own microsoft id to get to my tile / dashboard to display on a web page. Any thoughts?
Note the most relevant articles I found appear to be as follows:
Authenticate a client app (all .net examples): https://msdn.microsoft.com/en-US/library/dn877545.aspx
Power BI API updates (gives javascript examples for everything but getting access token - which stinks!): http://blogs.msdn.com/b/powerbidev/archive/2015/09/23/power-bi-api-updates-roundup.aspx
Integrate a Power BI tile into an app: https://msdn.microsoft.com/en-US/library/mt450498.aspx
Intro to creating a Power BI app: https://msdn.microsoft.com/en-US/library/mt186546.aspx
Service to Service Calls Using Client Credentials: https://msdn.microsoft.com/en-us/library/azure/dn645543.aspx
And, of course, I am not the only person who wants to know: http://community.powerbi.com/t5/Integrations-with-Files-and/Example-Request-How-to-Authenticate-Sile...
So, how the heck to we do this so I can put a chart up on a web page?
Thank you all.
Did you have any results?? Im right now with the same problem but trying to push data in some datasets regularly.
Couldn't find any examples nor routines to get a token with JS.
Actually, we did. This is a few months old, but here is what we found...
I am actually going to sharea complete set of findings related to putting PowerBI in an iFrame... ADX Studio has the iFrame, but the answer to your question is buried here.
Concepts:
Concepts:
Concepts:
Bump. Anyone have .js sample of obtaining an authorization code and access token for PowerBI?
Any updates on how to get a hold of the access token???
My understanding is that, unless it is provided as a specific Connector in Power Query (e.g. Facebook, SharePoint Online List maybe), Power BI doesn't currently support the full callback process for user-id/password authentication per oAuth2. Per http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/, "Power BI cannot read a response returned to a callback URL and if the API you are using requires that “authentication flow” then it can’t be used with Power BI (well, that is not entirely true, but to prevent this blog from being 50 pages long, we will say it can’t). For instance, the LinkedIn API requires this flow so it is not something we can connect to from Power BI easily."
It WILL work for an application-level token per that link showing access via public Twitter Search API.
To help get this service improved, consider voting for an (the best?) oAuth idea at https://ideas.powerbi.com/search?filter=ideas&query=oauth
I am also lost with trying to find the access token.
Hi, how did you pass the username and password for OAuth? I want to do the same in SharePoint, but I'm confused as how to get at the profile password? Thanks.