How to refresh a single table in PBI dataset from within Synapse pipelines?

Question

I have been trying to refresh a single table in PBI dataset from synapse pipelines but all I get is the refresh of whole dataset. I followed the below references to get to this point in implementation but not getting the expected results: https://microsoft-bitools.blogspot.com/2022/04/refresh-power-bi-datasets-with-adf-or.html

https://www.youtube.com/watch?v=43BkAkAVWio

https://microsoft-bitools.blogspot.com/2022/05/refresh-1-table-in-power-bi-dataset.html#:~:text=Refresh%20single%20table%20in%20PBI%20Dataset%20from%20within,5%205%29%20Create%20JSON%20message%20via%20SQL%20

The documentation asks us to provide the below as body in the web activity to refresh required tables but my pipeline is still triggering the complete dataset.

Any help in regards to this implementation would be very helpful.

Thank you

Answer 1

@Hitesh Madapathi
Thank you for the question and for using Microsoft Q&A platform.

Please make sure that you have followed all the steps mentioned in the references correctly. If you have followed all the steps correctly and still facing issues, then please check the following:

1. Make sure that you have provided the correct table name in the JSON message body. If the table name is incorrect, then the complete dataset will be refreshed.
2. And also, to accomplish this you need the XMLA endpoints in Power BI. Those XMLA endpoints provide access to the Analysis Services engine in Power BI giving you extra options for your dataset like only refreshing a single table (or a couple of tables). However, XMLA endpoints are only available for premium workspaces. So, you either need Power BI premium (capacity) or Power BI premium per user. This doesn't work for Power BI PRO.
3. Check if you have provided the correct URL in the web activity.
4. Check if you have provided the correct authentication details in the web activity.

If you have checked all the above points and still facing issues, then please provide me with more details like the JSON message body that you are using. This will help me to understand the issue better and provide you with a solution.

I hope this helps! Let me know if you have any further questions.

Answer 2

Accepted Answer here: https://learn.microsoft.com/en-us/answers/questions/2067955/refresh-a-single-table-in-pbi-dataset-from-within