Forum Discussion

speranzaa's avatar
speranzaa
Frequent Visitor
4 years ago
Solved

Data refresh on demand from Power BI Server (report built using Import mode)

Hi, using: Power Bi Desktop 2.100.1381.0 64-bit (January 2022) Power BI Report Server Version1.13.8086.22725(January 2022)   I created a tabular report in Import mode that retrieves data from DB...
data_refresh
  • d_gosbell's avatar
    d_gosbell
    4 years ago

    The answer by Anonymous is incorrect. The Power Automate (flow) and Power App solutions only work for the Power BI Service. There is not on-demand refresh built-in for the on-prem report server. If the user has permission to manage the scheduled refreshes they can go in and click the "Run Now" button on one of those, but you cannot link this into a report.

     

    If you have the expertise to build a web application you could probably use the Web API calls to generate a scheduled refresh and trigger the "run now" action, but that would be a fair bit of work.

d_gosbell's avatar
d_gosbell
Super User
4 years ago

The answer by Anonymous is incorrect. The Power Automate (flow) and Power App solutions only work for the Power BI Service. There is not on-demand refresh built-in for the on-prem report server. If the user has permission to manage the scheduled refreshes they can go in and click the "Run Now" button on one of those, but you cannot link this into a report.

 

If you have the expertise to build a web application you could probably use the Web API calls to generate a scheduled refresh and trigger the "run now" action, but that would be a fair bit of work.

speranzaa's avatar
speranzaa
Frequent Visitor
4 years ago

Thanks a lot d_gosbell,

at least now, I know in which direction I can proceed.