Problems with OAUTH 2.0

---

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.

 

---

tenenwurcel

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

    }

}