Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
So I have a mini project within my company, where the data source is an SQL Server Database.
I want the data to be automatically refreshed in Power BI, the issue is that I have a local gateway installed, and If the computer is turned off, the refresh wont work.
Any ideas as to how should I proceed?
Solved! Go to Solution.
@campelliann , You should install gateway on machine, which is always on. Install it on a new machine, where you can access sql server. Login using power bi user having access to that report and was gateway admin.
Add this gateway to power bi service and add the data source.
refer the steps : https://radacad.com/the-power-bi-gateway-all-you-need-to-know
@campelliann , You should install gateway on machine, which is always on. Install it on a new machine, where you can access sql server. Login using power bi user having access to that report and was gateway admin.
Add this gateway to power bi service and add the data source.
refer the steps : https://radacad.com/the-power-bi-gateway-all-you-need-to-know
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |