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 Everyone,
Good day!
I'm new to PBI and there's a task assigned to me. I need your guidance on this one. I have SQL as data source and it's on a Virtual Machine.
We have a new premium workspace and we try to migrate reports, but there's an error regarding gateway.
My Question is:
Do I need to install/setup gateway on my local device or the gateway should be installed in the VM?
Thanks in advance.
Solved! Go to Solution.
It is probably nest to install the Gateway on the SQL Server itself. Basic requirements:
1) be able to communicate (be in the same domain as) the machine that holds the data
2) Have appropriate drivers installed. So if you are connecting to, say, an Oracle server, the Gateway machine must have the Oracle drivers installed, plus the propert TNS entries, etc.
3) NOT be a Domain Controller.
But generally speaking, if all you are grabbing is SQL data, put the Gateway on that server.
Proud to be a Super User! | |
It is probably nest to install the Gateway on the SQL Server itself. Basic requirements:
1) be able to communicate (be in the same domain as) the machine that holds the data
2) Have appropriate drivers installed. So if you are connecting to, say, an Oracle server, the Gateway machine must have the Oracle drivers installed, plus the propert TNS entries, etc.
3) NOT be a Domain Controller.
But generally speaking, if all you are grabbing is SQL data, put the Gateway on that server.
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |