Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
mihirsp1988
Frequent Visitor

Power BI Embedded API - Updating a specific table in dataset

Hello,

 

I am trying to use PBI API to refresh a specific table in dataset rather than full dataset. I've used following code to refresh only table1 in dataset. But it seems like refreshing all tables. 

 

 

var parameters = new Dictionary<string, string>
            {
                { "table", "Table1" },
                { "refreshType", "Full" }
            };
            
            HttpClient client = new HttpClient();
            client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", accessToken);
            try
            {
                var test = await client.PostAsJsonAsync($"https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetid}/refreshes",
                new StringContent(JsonConvert.SerializeObject(parameters), Encoding.UTF8, "application/json"));
            }
            catch (System.Exception)
            {

                throw;
            }

 

 

Where as if I use XMLA endpoint - I can refresh only one single table.

 

Can you please suggest what am I doing wrong here? Also, what is the best way to see it's refresing all tables as I am going through only time it takes to refresh dataset? Wiht single table it take 10 seconds where as whole dataset takes longer and it's consistent accros Dev, Test and Prod environemnt.  

1 ACCEPTED SOLUTION

I tried this but it still did not work.

 

After looking into details I think the issue is around how I code my request body in JSON. Beacause when I used following code it started working and I can see Enhanced API as request type in PBI service.

Following the final code I used:

var body = @"{
                " + "\n" +
                @"    ""type"": ""Full"",
                " + "\n" +
                @"    ""commitMode"": ""transactional"",
                " + "\n" +
                @"    ""maxParallelism"": 2,
                " + "\n" +
                @"    ""retryCount"": 2,
                " + "\n" +
                @"    ""objects"": [
                " + "\n" +
                @"        {
                " + "\n" +
                @"            ""table"": ""TableName""
                " + "\n" +
                @"            
                " + "\n" +
                @"        }
                " + "\n" +
                @"    ]
                " + "\n" +
                @"}";

            HttpClient client = new HttpClient();
            client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", aadService.GetAccessToken());
            try
            {
                var test = await client.PostAsync($"https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetId}/refreshes",
                                   new StringContent(body, Encoding.UTF8, "application/json"));
            }
            catch (System.Exception)
            {
                throw;
            }

 

Thanks Ibendlin for your support.

View solution in original post

4 REPLIES 4
mihirsp1988
Frequent Visitor

Thanks Ibendlin. I've also tried that but whenever I try it from Enhanced refresh it works fine but it does not work from my code. 

The new code I used is as below:

var accessToken = aadService.GetAccessToken();
            //var parameters = new Dictionary<string, string>
            //{
            //    { "table", "{tablename}" },
            //    { "refreshType", "Full" }
            //};
            string jsonText = "{\r\n  \"type\": \"full\",\r\n  \"commitMode\": \"transactional\",\r\n  \"objects\": [\r\n      {\r\n        \"database\": \"{Databasename}\",\r\n        \"table\": \"{tableName}\"\r\n      }\r\n    ],\r\n  \"applyRefreshPolicy\": \"false\"\r\n}";
            HttpClient client = new HttpClient();
            client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", accessToken);
            try
            {
                var test = await client.PostAsJsonAsync($"https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes",
                //new StringContent(JsonConvert.SerializeObject(parameters), Encoding.UTF8, "application/json")
                jsonText);
            }
            catch (System.Exception)
            {

                throw;
            }

Is it something wrong with my code?

 

Thanks,

Mihir

 

Applyrefreshpolicy = false will force a full refresh of all dependent partitions.

I tried this but it still did not work.

 

After looking into details I think the issue is around how I code my request body in JSON. Beacause when I used following code it started working and I can see Enhanced API as request type in PBI service.

Following the final code I used:

var body = @"{
                " + "\n" +
                @"    ""type"": ""Full"",
                " + "\n" +
                @"    ""commitMode"": ""transactional"",
                " + "\n" +
                @"    ""maxParallelism"": 2,
                " + "\n" +
                @"    ""retryCount"": 2,
                " + "\n" +
                @"    ""objects"": [
                " + "\n" +
                @"        {
                " + "\n" +
                @"            ""table"": ""TableName""
                " + "\n" +
                @"            
                " + "\n" +
                @"        }
                " + "\n" +
                @"    ]
                " + "\n" +
                @"}";

            HttpClient client = new HttpClient();
            client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", aadService.GetAccessToken());
            try
            {
                var test = await client.PostAsync($"https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetId}/refreshes",
                                   new StringContent(body, Encoding.UTF8, "application/json"));
            }
            catch (System.Exception)
            {
                throw;
            }

 

Thanks Ibendlin for your support.

lbendlin
Super User
Super User

Your parameters have the wrong structure.

 

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.