Power Automate: Run a json query against a dataset. Can I use it for Dataset table refresh?

[EduardD]

Hi there, 
there is a Power Automate action: Run a json query against a dataset.
Can I use it for Dataset table refresh? I tried to use TMSL Json with information on table names (See below). but it always returns bad request - At least one query needs to be provided. 
XMLA R/W is on, everything is hosted on Fabric capcity

_____

PS: JSON code for refresh
{
"refresh": {
"type": "full",
"objects": [
{
"database": "YourDatasetName",
"table": "Table1"
},
{
"database": "YourDatasetName",
"table": "Table2"
}
]
}
}

[lbendlin]

Why not use the default REST API calls for that?

[EduardD]

@lbendlin  thank you!  what the name of this action? Do you have a link to this action documentation? 
Is it HTTP With Microsoft Entra ID (Premium)?

[lbendlin]

You could use that -  we decided to create a custom connector for these API calls.

[EduardD]

Is it prem feature? What do you use for auth, can it use current user or we need to create service principal? If you have sample code I would appreciate.

[lbendlin · Accepted solution]

It's not a premium feature, and we use OAuth (and I believe SPN as well). 

Here's the documentation.

Custom connectors overview | Microsoft Learn

I can share a snippet of the swagger file if interested

[v-sgandrathi]

 Hi @EduardD,

I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-sgandrathi]

Hi  @EduardD,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @EduardD,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

Your understanding and patience will be appreciated.