Forum Discussion
Refreshing specific table of Dataset using Power Shell through Rest API
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.
https://www.youtube.com/watch?v=Tdhy4BcqvyM
Thanks in Advance.
4 Replies
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.
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!Here you go
I can't beat MSFT on explaining it 🙂
