Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.