loading the start time and End time for table and partition level on dataset refresh via api

[naveenvnit]

I want to get the start time and endtime completion of semantic model refresh on table and partion level thru api

I saw https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-execution-details-in-group#... generates the dataset refresh information. But it returns only entire refresh start time and end time. But not in the table and partiton level.

Please suggest how can i get the start and end time in the table and partition level.

[Rajesh_Yarlagad]

Lets say we are doing a full refresh of  one specific table through XMLA End point in SSMS. How can we find out what is the time taken for refresh for that single table? Is there any way to do that ? 

[Anonymous · Accepted solution]

Hi,@naveenvnit. Hello,@GilbertQ,Thank you very much for your help of this issue.
Now I want to share other suggestions with you.
 

According to your description, you want to get the refresh start time and end time of the table and partition in semantic model at the time of refresh.

Here is my suggestion, you can refer to it.
Use XMLA endpoint combined with API for refresh setting

If your semantic model is hosted in premium capacity, then you can use xmla endpoint to help you realize your needs.

For example you can remotely access the semantic model in the workspace via SSMS and manage it (manage tables/partitions)
like this：
when you refresh the semantic model in the power bi service,the result of the “Last Processed” will update. The ”Last Processed”  shows the end time of the processed partition.
You can get the processing time of a single partition by calculating the processing end time of neighboring partitions.

XMLA is a communication protocol for data transfer and data communication with other data sources, which enables remote management of elements on the power bi service.

Here is the official document about the introduction of XMLA
URL:Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...
My testing process is as follows:
1. Enable XMLA Endpoint read/write functionality.

2.Copy the link  url of the worksapce( Need Premium Per User  license or Premium capacity)

3.Connect to the SQL Server Management Studio

Connect successful and you can see all the databases(the semantic model in power BI service)

Now you can the the partions of the table and when you refresh the semantic model(by API or others ways),the results of the Last Processed will change

The case I'm showing is a semantic model configured for incremental refresh, so after performing the refresh, only the data in the intervals within the refresh range were subjected to the refresh operation

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @naveenvnit 

The only way that I know that you can get this information is by using log Analytics on a premium or premium per user at workspace. Here are more details on log analytics. Configure Azure Log Analytics in Power BI - Power BI | Microsoft Learn