How to refresh a single table in Power BI service using Azure logic app

[amikm]

I have a Power BI dataset that has 5 tables in it. I want to refresh the 1 table out of those 5 tables. 

Using XMLA endpoint, I am able to connect that Power BI dataset and able to execute this in SQL Server Management studio. But this process is manual.

I followed the below youtube video 

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

I am trying to get it done using the Azure logic app. Do we have an anyway so that we can do this in the Logic app or even automate this in SSMS?

[andyclap]

I'm doing just this at the minute. As usual there is a load of half-baked misinformation, outdated, and just plain wrong answers in these forums and elswhere. It's just a nightmare.

Forget XMLA endpoint - that's a redherring (OpenAI recommends that for some reason).

[amitchandak]

@amikm , The way could be power bi cmdlets or Power bi rest API. But I doubt I saw any option for table refresh

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset

[amikm]

Hi @amitchandak , Can we use XMLA endpoint in the logic app as I can see using XMLA endpoint we can connect to ssms and refresh individual tables but I am trying to automate this process. 

[Resta_899]

Did you have any luck ?