Define tracked properties for Power BI dataset refresh

[Caramba87]

Hi everyone, 

I want to define Tracked properties for refreshing a Power BI dataset.

The output structure is as follows if the refresh is successful:

{

   "statusCode": 200,

   "headers": {

      “Pragma": "no-cache", 

     .... 

  } 

} 

I am able to get the status as tracked property by using :

"@outputs('Refresh_a_dataset')? ['statusCode']" 

When an error occurs the outputs are as follows :

{

   "statusCode": 400,

   "headers": {

      “Pragma": "no-cache", 

     .... 

  }, 

   "body" :{

      "error" : {

         "code": "Invalid Request", 

         "message": "Error message..." 

        } 

     }

} 

Now if I am trying to get the 'message' or any other content from 'body' the output via Compose: Actions('Refresh_a_dataset').trackedProperties['Error']) or Actions('Refresh_a_dataset')?['Error'] remains empty 

What would be the correct way and syntax to get the message as tracked property in this case? Accesing the "statusCode" works:

Thanks for your help! 

[v-xiaochen-msft · Accepted solution]

Hi @Caramba87 ,

Please try this:

outputs('Refresh_a_dataset')? ['body/error/message']

Best Regards,

Wearsky

[Caramba87]

Hi @v-xiaochen-msft ,

unfortunately also no success with this approach. I´m stll just getting output for the "statusCode".

Edit:

Your solution was correct. I could access the tracked properties via composing Actions('Refresh_a_dataset')?['trackedProperties'] - then I´ve been able to read both properties using the outputs of the compose action: outputs('Compose_properties')?['Error']

Best Regards,

Caramba87