Connecting to on-prem shared drive and auto refreshed on PowerBI Report Server

[Anonymous]

Hi 

I have a few files that is currently housed in my office network drive (on Prem). I am pulling it daily by having a human to click on the refresh button. The report is then shared on the PowerBI Report Server. Would like to know if there any way that I an schedule a auto refresh daily? Is the Gateway required?

Thank you

[Anonymous]

Hi thanks for the reply but seems like I do not have it. 

Am I correct that I need to do this first? - Permissions are defined in the role definitions for the report server.

[Shahfaisal]

Yes you need to get the right permissions first. Please note that you can't give permissions to your own account. I would reach out to your Report Server admin.

Also, as mentioned in the article, prior to creating a schedule data refresh , you need to set the credentials for each data source used in your Power BI report.

[Anonymous]

Thank you. 

As for this, my current data source is on my company network drive (on-prem). How can I setup the credentials for the data source?

[Shahfaisal]

---

@Anonymous wrote:

Thank you. 

As for this, my current data source is on my company network drive (on-prem). How can I setup the credentials for the data source?

---

Just like how you did in Power BI Desktop. First you will need enough permissions on the Report Server.

[Shahfaisal]

You can setup a schduled refresh in Power BI Report Server. Take a look at https://learn.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh