Solved: Refresh SQL Server 2017

FabioN · ‎04-03-2020

Hello all,

I have a Windows Server with an SQL Server 2017 I want to use as the source for Power BI.

I've chosen 'Import' as data source type, since I don't need data to be in real time.

I would like to set a scheduled nightly refresh so that my users (currently testing the Pro licence) get data of the last day when they open the service in browser.

Is this feasible? Do I need Power BI desktop on the server? Do user get automatic updates of the data when they login online?

Thank you very much!

Fabio

Jayendran · ‎04-04-2020

Hi @FabioN ,

Since you are using a on-premises sql server you need to use a powerbi onpremises gateway to schedule a refresh in powerbi service (app.powerbi.com)

Powerbi desktop is just a client tool to develop powerbi reports. If you install powerbi desktop in the server and open your report(pbix file), yes you will get the updated record in the server alone(on-premises) . In order to use the schedule refresh in powerbi service (cloud) you need a gateway.

View solution in original post

Jayendran · ‎04-04-2020

Hi @FabioN ,

Since you are using a on-premises sql server you need to use a powerbi onpremises gateway to schedule a refresh in powerbi service (app.powerbi.com)

Powerbi desktop is just a client tool to develop powerbi reports. If you install powerbi desktop in the server and open your report(pbix file), yes you will get the updated record in the server alone(on-premises) . In order to use the schedule refresh in powerbi service (cloud) you need a gateway.