Forum Discussion

StephenF's avatar
StephenF
Responsive 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...
  • 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.