Forum Discussion

Frequent Visitor

9 years ago

Solved

Generate Embed Token For Create Issue

Hello. I have an issue with getting embed token. I've done what's described in this link (https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-walkthrough-push-data/) and everything w...

Need Help

Eric_Zhang

9 years ago

Zirochka

I may doubt that there's some issue with the Power BI API lib, as I've found the token generation functions for reports, dashboards, tiles but not for datasets.

powerBIclient.Reports.GenerateTokenxxxxx
powerBIclient.Dashboards.GenerateTokenxxxxx
powerBIclient.Tiles.GenerateTokenxxxxx

So I guess for Datasets, it should be 
powerBIclient.Datasets.GenerateTokenxxxxx
Unfortunately, I'm not finding any GenerateTokenxxxxx for datasets

Instead of using the API lib, call the REST API directly.

using System;
//Install-Package Newtonsoft.Json 
using Newtonsoft.Json;
using System.Net;
using System.IO;

namespace GenerateEmbeddedToken
{
    class Program
    {
        static void Main(string[] args)
        {
            string EmbedTokenForDataSet = generateEmbedTokenForDataSet("the groupID", "the datasetID", "eyxxxxxxxxxtoken");

            Console.WriteLine(EmbedTokenForDataSet);
            Console.ReadKey();
        }


        private static string generateEmbedTokenForDataSet(string groupID, string datasetID, string accessBearerToken)
        {
            string embedToken = "";
            HttpWebRequest request = System.Net.HttpWebRequest.CreateHttp(String.Format("https://api.powerbi.com/v1.0/myorg/groups/{0}/reports/GenerateToken", groupID));
            //POST web request to create a datasource.
            request.KeepAlive = true;
            request.Method = "POST";
            request.ContentType = "application/json";
             
            //Add token to the request header
            request.Headers.Add("Authorization", String.Format("Bearer {0}", accessBearerToken));

            string PostData = "{"+
                                      "\"accessLevel\": \"Create\","+
                                      "\"datasetId\": \""+datasetID+"\","+
                                      "\"allowSaveAs\": true"+
                                    "}";

            byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(PostData); 

            try
            {
                //Write JSON byte[] into a Stream
                using (Stream writer = request.GetRequestStream())
                {
                    writer.Write(byteArray, 0, byteArray.Length);
                    var response = (HttpWebResponse)request.GetResponse(); 
                    var responseJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
                    dynamic responseString = JsonConvert.DeserializeObject<dynamic>(responseJson.ToString());
                    embedToken = responseString["token"];
                }
            }
            catch (WebException wex)
            {
                if (wex.Response != null)
                {
                    using (var errorResponse = (HttpWebResponse)wex.Response)
                    {
                        using (var reader = new StreamReader(errorResponse.GetResponseStream()))
                        {
                            string errorString = reader.ReadToEnd();
                            dynamic respJson = JsonConvert.DeserializeObject<dynamic>(errorString);
                            Console.WriteLine(respJson.toString());
                            //TODO: use JSON.net to parse this string and look at the error message
                        }
                    }
                }
            }

            return embedToken;
        }
    }
}

Eric_Zhang

Microsoft Employee

9 years ago

Zirochka

I may doubt that there's some issue with the Power BI API lib, as I've found the token generation functions for reports, dashboards, tiles but not for datasets.

powerBIclient.Reports.GenerateTokenxxxxx
powerBIclient.Dashboards.GenerateTokenxxxxx
powerBIclient.Tiles.GenerateTokenxxxxx

So I guess for Datasets, it should be 
powerBIclient.Datasets.GenerateTokenxxxxx
Unfortunately, I'm not finding any GenerateTokenxxxxx for datasets

Instead of using the API lib, call the REST API directly.

using System;
//Install-Package Newtonsoft.Json 
using Newtonsoft.Json;
using System.Net;
using System.IO;

namespace GenerateEmbeddedToken
{
    class Program
    {
        static void Main(string[] args)
        {
            string EmbedTokenForDataSet = generateEmbedTokenForDataSet("the groupID", "the datasetID", "eyxxxxxxxxxtoken");

            Console.WriteLine(EmbedTokenForDataSet);
            Console.ReadKey();
        }


        private static string generateEmbedTokenForDataSet(string groupID, string datasetID, string accessBearerToken)
        {
            string embedToken = "";
            HttpWebRequest request = System.Net.HttpWebRequest.CreateHttp(String.Format("https://api.powerbi.com/v1.0/myorg/groups/{0}/reports/GenerateToken", groupID));
            //POST web request to create a datasource.
            request.KeepAlive = true;
            request.Method = "POST";
            request.ContentType = "application/json";
             
            //Add token to the request header
            request.Headers.Add("Authorization", String.Format("Bearer {0}", accessBearerToken));

            string PostData = "{"+
                                      "\"accessLevel\": \"Create\","+
                                      "\"datasetId\": \""+datasetID+"\","+
                                      "\"allowSaveAs\": true"+
                                    "}";

            byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(PostData); 

            try
            {
                //Write JSON byte[] into a Stream
                using (Stream writer = request.GetRequestStream())
                {
                    writer.Write(byteArray, 0, byteArray.Length);
                    var response = (HttpWebResponse)request.GetResponse(); 
                    var responseJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
                    dynamic responseString = JsonConvert.DeserializeObject<dynamic>(responseJson.ToString());
                    embedToken = responseString["token"];
                }
            }
            catch (WebException wex)
            {
                if (wex.Response != null)
                {
                    using (var errorResponse = (HttpWebResponse)wex.Response)
                    {
                        using (var reader = new StreamReader(errorResponse.GetResponseStream()))
                        {
                            string errorString = reader.ReadToEnd();
                            dynamic respJson = JsonConvert.DeserializeObject<dynamic>(errorString);
                            Console.WriteLine(respJson.toString());
                            //TODO: use JSON.net to parse this string and look at the error message
                        }
                    }
                }
            }

            return embedToken;
        }
    }
}

Zirochka

Frequent Visitor

9 years ago

I tried to use your function, but it didn't help.

using System;
//Install-Package Newtonsoft.Json 
using Newtonsoft.Json;
using System.Net;
using System.IO;

namespace GenerateEmbeddedToken
{
    class Program
    {
        static void Main(string[] args)
        {
            string EmbedTokenForDataSet = generateEmbedTokenForDataSet("the groupID", "the datasetID", "eyxxxxxxxxxtoken");

            Console.WriteLine(EmbedTokenForDataSet);
            Console.ReadKey();
        }


        private static string generateEmbedTokenForDataSet(string groupID, string datasetID, string accessBearerToken)
        {
            string embedToken = "";
            HttpWebRequest request = System.Net.HttpWebRequest.CreateHttp(String.Format("https://api.powerbi.com/v1.0/myorg/groups/{0}/reports/GenerateToken", groupID));
            //POST web request to create a datasource.
            request.KeepAlive = true;
            request.Method = "POST";
            request.ContentType = "application/json";
             
            //Add token to the request header
            request.Headers.Add("Authorization", String.Format("Bearer {0}", accessBearerToken));

            string PostData = "{"+
                                      "\"accessLevel\": \"Create\","+
                                      "\"datasetId\": \""+datasetID+"\","+
                                      "\"allowSaveAs\": true"+
                                    "}";

            byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(PostData); 

            try
            {
                //Write JSON byte[] into a Stream
                using (Stream writer = request.GetRequestStream())
                {
                    writer.Write(byteArray, 0, byteArray.Length);
                    var response = (HttpWebResponse)request.GetResponse(); 
                    var responseJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
                    dynamic responseString = JsonConvert.DeserializeObject<dynamic>(responseJson.ToString());
                    embedToken = responseString["token"];
                }
            }
            catch (WebException wex)
            {
                if (wex.Response != null)
                {
                    using (var errorResponse = (HttpWebResponse)wex.Response)
                    {
                        using (var reader = new StreamReader(errorResponse.GetResponseStream()))
                        {
                            string errorString = reader.ReadToEnd();
                            dynamic respJson = JsonConvert.DeserializeObject<dynamic>(errorString);
                            Console.WriteLine(respJson.toString());
                            //TODO: use JSON.net to parse this string and look at the error message
                        }
                    }
                }
            }

            return embedToken;
        }
    }
}

On line:

using (Stream writer = request.GetRequestStream())

program thinks for approximately 30 seconds and then goes to catch block.

In catch block if statement is false (so, Response == null) and program just goes out from catch.

That's all.

I still don't understant why it happens because I just use this guide for POST requests (https://msdn.microsoft.com/library/mt784614.aspx). And it's up to date (Updated: July 21, 2017), so, I don't understand.

I'll appresiate any help.

Eric_Zhang

Microsoft Employee

9 years ago

Zirochka wrote:

I tried to use your function, but it didn't help.

using System;
//Install-Package Newtonsoft.Json 
using Newtonsoft.Json;
using System.Net;
using System.IO;

namespace GenerateEmbeddedToken
{
    class Program
    {
        static void Main(string[] args)
        {
            string EmbedTokenForDataSet = generateEmbedTokenForDataSet("the groupID", "the datasetID", "eyxxxxxxxxxtoken");

            Console.WriteLine(EmbedTokenForDataSet);
            Console.ReadKey();
        }


        private static string generateEmbedTokenForDataSet(string groupID, string datasetID, string accessBearerToken)
        {
            string embedToken = "";
            HttpWebRequest request = System.Net.HttpWebRequest.CreateHttp(String.Format("https://api.powerbi.com/v1.0/myorg/groups/{0}/reports/GenerateToken", groupID));
            //POST web request to create a datasource.
            request.KeepAlive = true;
            request.Method = "POST";
            request.ContentType = "application/json";
             
            //Add token to the request header
            request.Headers.Add("Authorization", String.Format("Bearer {0}", accessBearerToken));

            string PostData = "{"+
                                      "\"accessLevel\": \"Create\","+
                                      "\"datasetId\": \""+datasetID+"\","+
                                      "\"allowSaveAs\": true"+
                                    "}";

            byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(PostData); 

            try
            {
                //Write JSON byte[] into a Stream
                using (Stream writer = request.GetRequestStream())
                {
                    writer.Write(byteArray, 0, byteArray.Length);
                    var response = (HttpWebResponse)request.GetResponse(); 
                    var responseJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
                    dynamic responseString = JsonConvert.DeserializeObject<dynamic>(responseJson.ToString());
                    embedToken = responseString["token"];
                }
            }
            catch (WebException wex)
            {
                if (wex.Response != null)
                {
                    using (var errorResponse = (HttpWebResponse)wex.Response)
                    {
                        using (var reader = new StreamReader(errorResponse.GetResponseStream()))
                        {
                            string errorString = reader.ReadToEnd();
                            dynamic respJson = JsonConvert.DeserializeObject<dynamic>(errorString);
                            Console.WriteLine(respJson.toString());
                            //TODO: use JSON.net to parse this string and look at the error message
                        }
                    }
                }
            }

            return embedToken;
        }
    }
}

On line:

using (Stream writer = request.GetRequestStream())

program thinks for approximately 30 seconds and then goes to catch block.

In catch block if statement is false (so, Response == null) and program just goes out from catch.

That's all.

I'll appresiate any help.

Zirochka

Have you got any API console tool for testing purpose? If not, I'd suggest using POSTMAN.

So beforing coding in C#, can you test this GenerateToken in postman? For any issue, feel free to post.

Zirochka
Frequent Visitor
9 years ago
Thanks for this Postman. It's really useful tool. Thanks a lot.
I tried to sent in this postman post request (from here https://msdn.microsoft.com/library/mt784614.aspx for dataset) and I got an answer with embed token. I checked this token here (https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html) and it works. Dataset loads to this example.

But I don't understand why from C# it doesn't works.
In my code I have another POST requests: when I create dataset (first POST) and when I push data to the dataset (second POST). And they works perfectly (I checked hundred times). But this (when I get embed token) POST (it's third POST in my code) does't work. And I found out that API works fine (thanks to postman).
Do you have any idea?

I'll appreciate any help.
- Eric_Zhang
  Microsoft Employee
  9 years ago
  Zirochka wrote:
  
  Thanks for this Postman. It's really useful tool. Thanks a lot.
  
  I tried to sent in this postman post request (from here https://msdn.microsoft.com/library/mt784614.aspx for dataset) and I got an answer with embed token. I checked this token here (https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html) and it works. Dataset loads to this example.
  
  But I don't understand why from C# it doesn't works.
  
  In my code I have another POST requests: when I create dataset (first POST) and when I push data to the dataset (second POST). And they works perfectly (I checked hundred times). But this (when I get embed token) POST (it's third POST in my code) does't work. And I found out that API works fine (thanks to postman).
  
  Do you have any idea?
  
  I'll appreciate any help.
  
  Zirochka
  
  I'd say the C# code in my first indeed works as long as the groupid and datesetid are correct. In your case, as the generate embedtoken POST request works in POSTMAN, so I think you could debug your code and figure it out.
  
  As to your "another POST requests", this is one issue as I tested in this thread and you can use the workaround from orginal poster.

Forum Discussion

Generate Embed Token For Create Issue

Related content

Lakehouse Table Generate Create Table

Issue with Embed Token Generation and RLS in Composite Model (Upstream/Downstream Datasets)

Generating Missing Data

Embed WebGL

Generate some views create script