topic Refreshing specific table of Dataset using Power Shell through Rest API in Service

Refreshing specific table of Dataset using Power Shell through Rest API

Raghav_Acc — Mon, 11 Dec 2023 12:20:54 GMT

Hi Everyone,

We've a requirement to refresh a specific table of the dataset using Rest API. When I explored, I found multiple solutions and was able to do it using HTTP connector in Power Automate. However, as HTTP connector requires to get a premium license we're looking for alternate solution to refresh a specific table of dataset apart from Power Automate or which doesn't require to spend additional cost.

Below is the reference video that can refresh complete dataset through PowerShell Rest API, But I'm looking at refreshing only a specific table of dataset.

mohammedadnant

https://www.youtube.com/watch?v=Tdhy4BcqvyM

Thanks in Advance.

Re: Refreshing specific table of Dataset using Power Shell through Rest API

aj1973 — Mon, 11 Dec 2023 14:07:26 GMT

Hi Raghav_Acc

It is not possible to refresh a specific Table into a Dataset. If it is very necessary then you might think of other solution like creating a Dataflow for that specific table or another separate Dataset containing that Table and then Get it from the AAS.

Re: Refreshing specific table of Dataset using Power Shell through Rest API

Raghav_Acc — Mon, 11 Dec 2023 14:18:59 GMT

Hi aj1973,
Thanks for your response. Can you provide more info on having it implemented using dataflow approach.
Also, I'm able to achieve the single table refresh using the Power Automate approach and the solution is attached. So exploring for alternate options that can be done without any additional license cost.

Thanks!

Re: Refreshing specific table of Dataset using Power Shell through Rest API

aj1973 — Mon, 11 Dec 2023 14:22:55 GMT

Here you go

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service

I can't beat MSFT on explaining it 🙂

Re: Refreshing specific table of Dataset using Power Shell through Rest API

Tracy000 — Wed, 31 Jul 2024 02:01:06 GMT

Hi Raghav_Acc

I have a same requirement to refresh a specific table in power bi dataset. I tried the same method as you put here but failed with 401 error DENY. May I know if you succeeded with this method finally?
Looking forward your reply, thanks in advance.