Refreshing specific table of Dataset using Power Shell through Rest API

[Raghav_Acc]

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. 

[aj1973]

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.

[Raghav_Acc]

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!

[Tracy000]

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.

[aj1973]

Here you go

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

I can't beat MSFT on explaining it 🙂