Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Dashboard refresh

Hi All,

 

I have developed a dashboard using Power BI (Import Mode). We scheduled it for refresh and after the refresh runs, the dashboard gets updated in the web portal. But, if I download it and open it in the Power BI Desktop, the data does not refresh without again clicking on refresh in the Power BI Desktop too. The problem is we do not want to provide the end user the access to the database, and hence, when the user clicks on refresh in the Power BI Desktop, it asks for credentials and does not refresh.

Can someone please suggest a way around? Or are there any APIs to achieve this? I read online that data refresh can be achieved using APIs in Power BI Service. I was hoping to know if there are any for on-premises version? We are using Power BI Report Server January 2019.

Thanks 

Power BI Report Server

1 Reply

  • luisrh's avatar
    luisrh
    Responsive Resident
    7 years ago

    I would assume that your users should be consuming the reports from the portal and not Power BI desktop.

    Why would the user want to consume the report from PBI desktop.   The reason for the publishing to portal is to keep the users isolated from what you can do in PBI desktop.   PBI desktop is really a designer tool when you use it within PBI Report Server.    There is a PBI REST API,  but again this acts on data on the server rather than on the client (PBI Desktop).

    Here is a link to it -    https://app.swaggerhub.com/apis/microsoft-rs/SSRS/PBI3.0#/

     

    Good luck!

    Luis