Forum Discussion
Helper VHow to refresh a single table in Power BI service using Azure logic app
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?
4 Replies
- amitchandak
Super User
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
amikmHi 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.
Did you have any luck ?
- andyclap
Advocate IV
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).
