Forum Discussion
Helper IQuerying Refresh Status for Refresh Initiated with TMSL (on Power BI Premium)
Hello,
On Power BI Premium, is there any way to query the status of a refresh initiated by TMSL?
Some background:
We have a need to initiate a dataset refresh specifying the Effective Date. This seems to be available only via TMSL, not via REST API.
However, as far as I can see TMSL does not seem to include commands for querying refresh status. Also as far as I can see, when a refresh is inititated with TMSL it is not recorded on Power BI Service, so querying the refresh history of the dataset does not return the refresh initiated with TMSL.
Thanks in advance for any pointers
3 Replies
v-deddai1-msftCommunity Support
Hi bongmw ,
You could use the api to get the refresh history, it contains OnDemand, Scheduled and ViaApi. Please refer to https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory#refreshtype
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
bongmwHi v-deddai1-msft ,
I tried this. If the refresh was initiated using TMSL, the refresh attempt is not visible from the refresh history.
I presume the refresh history only handles the PBI Service side of things?
- v-deddai1-msft
Hi bongmw ,
It seems that you are right. I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Dedmon Dai