Sementic Model refresh for cache

[munindra]

i created a PBI report using sql server using direct query method and published it into microsoft fabric.Although pbi report is working fine but after publishing inside the fabric the sementic model needs to manually refresh or have refresh rate of minimum 15 min . if i want to implent semetic model refresh using pipeline it return the error 
{"error":{"code":"InvalidRequest","message":"Invalid data. This API can only be called on a Model-based data"}}
after this i found  that this pipeline is used for data refresh not cache refresh 
could any one help me to automate the cache refresh rate of the sementic model in the fabric workspace

[freginier · Accepted solution]

Hi there! 

You could use the Use REST API to Trigger a Refresh. Power BI allows refreshing DirectQuery Cache using the Power BI REST API. 

Use the refresh dataset API: POST https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes (This forces Power BI to clear and refresh cached results.) 

Heres how you can do this: 

- Get your dataset ID from the Power BI workspace.
- Set up an Azure Logic App or Power Automate flow to call the API at your desired frequency.

Hope this helps!

😁😁

[v-sgandrathi]

Hi @munindra,

Thankyou @freginier for your reply on the issue.

I'm glad to hear that your query was resolved! If the response provided by the community member addressed your concern, kindly confirm.

Marking it as Accept Answer and give us Kudos if you found it helpful allows us to ensure that the solutions shared are valuable for the entire community.

If you have any further questions, feel free to reach out!

Thank you for your cooperation!

[v-sgandrathi]

Hi @munindra,

I wanted to check if you had the opportunity to review the information provided by the super user. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Thanks for connecting with the Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @munindra,

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.

Thanks for connecting with the Microsoft Fabric Community Forum.