Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
Solved! Go to Solution.
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.
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.