Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Refresh button is not working

I have created a dashboard in Power BI and embedded a refresh button in order to refresh the data whenever the business user want. This refresh button was created using power automation option in desktop. But when publish it to the power bi service port it's not working. The source for the data source for this report was share point portal.

 

Any help much appreciated. 

Dataflow
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous 
    Thank you for reaching out microsoft fabric community forum.

    • When publishing to Power BI Service, you need to ensure that your Power Automate flow is connected to the published dataset in the service, not just the local version in Power BI Desktop. Open Power Automate, edit your flow, and make sure the dataset in the service is selected.
    • Your Power Automate flow must have permission to refresh the dataset in Power BI Service .Ensure your Power Automate flow uses a valid connection and has admin/editor access to the dataset.
    • Since your data source is SharePoint, Power BI Service requires valid credentials to refresh it. Go to Power BI Service → Settings → Dataset Settings and re-enter credentials for the SharePoint data source.
    • Even though you're using a manual refresh button, your dataset should have at least one scheduled refresh in Power BI Service. Enable Scheduled Refresh in Power BI Service to avoid permission issues.

      If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

      Thank you.

     

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Thanks for your reply. exactly followed the same steps as mentioned in that video but still not working, not sure is there any check point am missing. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for your reply. exactly followed the same steps as mentioned in that video but still not working, not sure is there any check point am missing. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 
    Thank you for reaching out microsoft fabric community forum.

    • When publishing to Power BI Service, you need to ensure that your Power Automate flow is connected to the published dataset in the service, not just the local version in Power BI Desktop. Open Power Automate, edit your flow, and make sure the dataset in the service is selected.
    • Your Power Automate flow must have permission to refresh the dataset in Power BI Service .Ensure your Power Automate flow uses a valid connection and has admin/editor access to the dataset.
    • Since your data source is SharePoint, Power BI Service requires valid credentials to refresh it. Go to Power BI Service → Settings → Dataset Settings and re-enter credentials for the SharePoint data source.
    • Even though you're using a manual refresh button, your dataset should have at least one scheduled refresh in Power BI Service. Enable Scheduled Refresh in Power BI Service to avoid permission issues.

      If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.

      Thank you.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 
    I wanted to check if you had the opportunity to review the information provided. 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 
    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
    Thank you.