Forum Discussion

munindra's avatar
munindra
Frequent Visitor
1 year ago
Solved

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 ...
Need Help
  • freginier's avatar
    freginier
    1 year ago

    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's avatar
v-sgandrathi
Community Support
1 year ago

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's avatar
v-sgandrathi
Community Support
1 year ago

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.