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!

    😁😁

freginier's avatar
freginier
Solution Sage
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,

    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'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.