Forum Discussion

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

Refresh data button

I wish to have a button in my powerBI to refresh the data. This report is embedded in my sharepoint and changes need to be cascaded through from a powerapp that updates my SQl data source.   Is the...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi StephenF 

    What kind of connection mode did you use to connect to SQL, import or  directquery?

    If you use import connection mode and you have pro license, you can install a gateway and configure schedule refresh(8 times per day).

    If you have premium license, your can set schedule refresh 48 times per day.

    If you use direct query mode to build your report, you can set your schedule cache refresh interval to 15 minutes .

    I think you may use embed to sharepoint function to embed your report to your sharepoint site.

    Your embed report will refresh automaticlly after you refresh your browser.

    Refresh succeed:

    Result is as below.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

StephenF is not a hack, it is a proper solution and no page shows up, not sure where you read that. I use it all the time.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • StephenF's avatar
    StephenF
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    Ok when the data refreshes in the data set does it cascade through to a powerBI embed on a sharepoint page then? Is there a guide?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi StephenF 

      What kind of connection mode did you use to connect to SQL, import or  directquery?

      If you use import connection mode and you have pro license, you can install a gateway and configure schedule refresh(8 times per day).

      If you have premium license, your can set schedule refresh 48 times per day.

      If you use direct query mode to build your report, you can set your schedule cache refresh interval to 15 minutes .

      I think you may use embed to sharepoint function to embed your report to your sharepoint site.

      Your embed report will refresh automaticlly after you refresh your browser.

      Refresh succeed:

      Result is as below.

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.