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.
Hello,
I've read a few related posts regarding this topic but still don't have a clear understanding. Just need to know if you have to have a gateway to refresh if you're connected to a SQL Server data source and using direct query storage mode.
Solved! Go to Solution.
Hi @jdwalker5 ,
For SQL Server you do need a gateway connection.
If by SQL Server you actually meant Azure SQL Database then you would not need a gateway connection.
Take a look at Power BI data sources - Power BI | Microsoft Docs. This explains which data sources require a gateway connection.
Hope this helps.
Proud to be a Super User!
Hi @jdwalker5 ,
For SQL Server you do need a gateway connection.
If by SQL Server you actually meant Azure SQL Database then you would not need a gateway connection.
Take a look at Power BI data sources - Power BI | Microsoft Docs. This explains which data sources require a gateway connection.
Hope this helps.
Proud to be a Super User!
Thank you for the link. That explains what I needed to know. The reason I ask is my organization uses both Power BI and Tableau. The Tableau folks don't understand why a gateway is necessary because I guess it refreshes data differently. I don't know enough about Tableau to speak to it.
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |