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.
Hey everyone,
I am trying to get the Power BI acess token, using the Microsoft.IdentityModel.Clients.ActiveDirectory library.
I was able to do so, doing the login manually. However my application is going to be used by my costumers who doesn't have access to Power BI Pro, what means that I need to do the login with my credentials, automatically.
This is my code:
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.IdentityModel.Clients.ActiveDirectory; namespace ConsoleApp1 { class Program { private static string token = string.Empty; static void Main(string[] args) { GetToken(); } #region Get an authentication access token private static async void GetToken() { string clientID = "myClientID"; string redirectUri = "myURI"; string resourceUri = "https://analysis.windows.net/powerbi/api"; string authorityUri = "https://login.windows.net/common/oauth2/authorize"; var credential = new UserCredential("myEmail", "myPassword"); AuthenticationContext authContext = new AuthenticationContext(authorityUri); var authenticationResult = await authContext.AcquireTokenAsync(resourceUri, clientID, credential); string token = authContext.AcquireToken(resourceUri, clientID, new Uri(redirectUri)).AccessToken; Console.WriteLine(token); Console.ReadLine(); } #endregion } }
I am for sure using the right redirectUri, clientID, and credentials, because I am able to login manually.
Is my code wrong? If so, could someone help me out with it?
Thank you very much,
Henrique.
Solved! Go to Solution.
@tenenwurcel wrote:
Hey everyone,
I am trying to get the Power BI acess token, using the Microsoft.IdentityModel.Clients.ActiveDirectory library.
I was able to do so, doing the login manually. However my application is going to be used by my costumers who doesn't have access to Power BI Pro, what means that I need to do the login with my credentials, automatically.
In this case, you need to purchase the Power BI Embedded capacity, see Embedding for your customers.
As to the code, below demo works in my test.
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.IdentityModel.Clients.ActiveDirectory; namespace ConsoleApp1 { class Program { private static string token = string.Empty; static void Main(string[] args) { Task<int> task = GetToken(); task.Wait(); Console.WriteLine(token); Console.ReadLine(); } #region Get an authentication access token private static async Task<int> GetToken() { string clientID = "{ClientID}"; string resourceUri = "https://analysis.windows.net/powerbi/api"; string authorityUri = "https://login.windows.net/common/oauth2/authorize"; var credential = new UserPasswordCredential("yourAccount", "YourPassword"); AuthenticationContext authContext = new AuthenticationContext(authorityUri); // Authenticate using created credentials var authenticationContext = new AuthenticationContext(authorityUri); var authenticationResult = await authenticationContext.AcquireTokenAsync(resourceUri, clientID, credential); token = authenticationResult.AccessToken; return 1; } #endregion } }
@tenenwurcel wrote:
Hey everyone,
I am trying to get the Power BI acess token, using the Microsoft.IdentityModel.Clients.ActiveDirectory library.
I was able to do so, doing the login manually. However my application is going to be used by my costumers who doesn't have access to Power BI Pro, what means that I need to do the login with my credentials, automatically.
In this case, you need to purchase the Power BI Embedded capacity, see Embedding for your customers.
As to the code, below demo works in my test.
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.IdentityModel.Clients.ActiveDirectory; namespace ConsoleApp1 { class Program { private static string token = string.Empty; static void Main(string[] args) { Task<int> task = GetToken(); task.Wait(); Console.WriteLine(token); Console.ReadLine(); } #region Get an authentication access token private static async Task<int> GetToken() { string clientID = "{ClientID}"; string resourceUri = "https://analysis.windows.net/powerbi/api"; string authorityUri = "https://login.windows.net/common/oauth2/authorize"; var credential = new UserPasswordCredential("yourAccount", "YourPassword"); AuthenticationContext authContext = new AuthenticationContext(authorityUri); // Authenticate using created credentials var authenticationContext = new AuthenticationContext(authorityUri); var authenticationResult = await authenticationContext.AcquireTokenAsync(resourceUri, clientID, credential); token = authenticationResult.AccessToken; return 1; } #endregion } }
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |