topic Re: Connecting to on-prem shared drive and auto refreshed on PowerBI Report Server in Report Server

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

Anonymous — Tue, 22 Nov 2022 07:03:24 GMT

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

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

Shahfaisal — Tue, 22 Nov 2022 15:47:02 GMT

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

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

Anonymous — Wed, 23 Nov 2022 00:05:39 GMT

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.

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

Shahfaisal — Wed, 23 Nov 2022 00:42:43 GMT

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.

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

Anonymous — Wed, 23 Nov 2022 02:13:19 GMT

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?

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

Shahfaisal — Wed, 23 Nov 2022 14:01:58 GMT

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.