Refresh button is not working

[saidareddy_madi]

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. 

[Anonymous]

Hi @saidareddy_madi 
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.

[Anonymous]

Hi @saidareddy_madi 
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]

Hi @saidareddy_madi 

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 · Accepted solution]

Hi @saidareddy_madi 
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.

[saidareddy_madi]

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. 

[Idrissshatila]

Hello @saidareddy_madi,

did you create a power automate flow to do the refresh ?

check this out https://youtu.be/-8NlEeIIRiQ?si=lsmJ7wCDWWgNSm0C

[saidareddy_madi]

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.