When I create a connection in Power BI desktop with ODBC connection string and System DSN it works well.
But when I create Data Source for same Report in Gateway the datasource does gets connected but while schduling refresh the same gateway does not reflect in list.
For Ex :- I have created Gateway Non-FDC which has 3 data sources which report XYZ has.Now when I try to schedule same report with Non-FDC gateway, it nowhere list that Gateway Option to select.
Please note the ODBC connection created at Desktop level is with System DSN and connection string. While same DSN & connection string I have mentioned for creating the data source.
Did you give yourself admin/usage privliages to the gateway? Did you set up the DSN's on the machine the gateway is installed on?
I'm not so sure for your datasource, can you please explain 'FDC' and 'DSN'?
In addition, it will be help if you provide some detail content to help us clarify your scenario.
For e.g. datasource type, connect mode, credentials, datasource settings, refresh log and history, screenshots...
Troubleshooting the on-premises data gateway
How to Get Your Question Answered Quickly
BTW, current power bi not support to use on premise gateway to host mixed online and on-premise data sources.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.