topic Re: Power BI Embedded API - Updating a specific table in dataset in Developer

Power BI Embedded API - Updating a specific table in dataset

mihirsp1988 — Wed, 17 May 2023 17:04:29 GMT

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.

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.

Re: Power BI Embedded API - Updating a specific table in dataset

lbendlin — Fri, 19 May 2023 01:34:03 GMT

Your parameters have the wrong structure.

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

Re: Power BI Embedded API - Updating a specific table in dataset

mihirsp1988 — Fri, 19 May 2023 09:40:54 GMT

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:

Is it something wrong with my code?

Thanks,

Mihir

Re: Power BI Embedded API - Updating a specific table in dataset

lbendlin — Fri, 19 May 2023 12:22:53 GMT

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

Re: Power BI Embedded API - Updating a specific table in dataset

mihirsp1988 — Fri, 19 May 2023 13:04:39 GMT

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:

Thanks Ibendlin for your support.