Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Schedule Refresh

Hi Team,

 

I have Power Bi report in Report Server in which data will be refreshed daily.

We can an option called Scheduled refresh to refresh the data at particular intervals of time daily and in that concept we have two data sources like EXCEL and SQL.

I have worked individually  for different reports with Excel as an input for one file and created a Scheduled Refresh - It worked and similar for SQl too.

 

Now I have an Requirement  that we have Two input files coming from two Data sources one is Excel and other is SQL .

So can i use both the Data sources in Single Power BI Report and Schedule the refresh?

Scheduled data refresh

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes., just try it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

       

      The Scheduled refresh with two input files, once is excel and other is SQL database has worked successfully,

      How ever in order to schedule the refresh we need to provide our user credentials at back end.

      and if the password expires after three months i need to update my password to all the Power BI report published in server.

      which is time consuming , do we have any other option for this?

      Can you please assist me.

       

       

      Thanks,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        Please create and use a service account and grant the permissions to the new account. This is the recommended way of using sources with authentication.