Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello there,
According the image below, the data gateway option is disabled.
but, my data gateway is working on and all connections is registred.
Necessary connections:
Registred connections:
Solved! Go to Solution.
Hi @ThalesFerraz,
Could you please elaborate more details about your scenario? We need to verify that if you install different types of gateway on the machine and if you add data sources under Personal Gateway or other Gateway.
If you add data sources under Personal Gateway, the phenomenon in the above screenshot is normal. However, if you add data sources under other type of Gateway such as Enterprise Gateway and wants to use the Enterprise Gateway, please make sure that the data source configured for the Enterprise Gateway are configured exactly as the Personal Gateway, otherwise the “Use a data gateway” option will be disabled. For more details, please review this similar thread.
Thanks,
Lydia Zhang
Hi @ThalesFerraz,
Could you please elaborate more details about your scenario? We need to verify that if you install different types of gateway on the machine and if you add data sources under Personal Gateway or other Gateway.
If you add data sources under Personal Gateway, the phenomenon in the above screenshot is normal. However, if you add data sources under other type of Gateway such as Enterprise Gateway and wants to use the Enterprise Gateway, please make sure that the data source configured for the Enterprise Gateway are configured exactly as the Personal Gateway, otherwise the “Use a data gateway” option will be disabled. For more details, please review this similar thread.
Thanks,
Lydia Zhang
I am facing similar issue. Posted in community.
Please have a look at:
https://ideas.powerbi.com/forums/360879-issues/suggestions/16616575-gateway-connection-disabled
Thanks.
EDIT:
Also observed that, while ADDing DATA SOURCE, it accepts SQL SERVER INSTANCE name instead of SQL Server IP/Name
(Which is usually accepted in SSMS).
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |