Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |