Forum Discussion
Sementic Model refresh for cache
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
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!
😁😁
4 Replies
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!
😁😁
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!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.
