Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Sir,
Is it Mandatory to have SQL server and Power BI desktop installed on same computer to prepare a Power BI report.
Is it possible to have a SQL server somewhere else in other computer and if we can connect it with Power BI desktop in our computer?
If yes then how?
Hello @Ramendra ,
What you could do is to connect to the sql on the same computer that has the sql server the sql in on premesis then import data to power bi then you could work on the report on any device you want but you can't refresh the data unless you're on the same pc that has the sql server or you report in in power bi service and you hve the sql connected through a data gateway.
learn more about on-premises data gateway https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
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 |
---|---|
109 | |
102 | |
85 | |
77 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |