cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srlabhe123
Post Patron
Post Patron

Gateway- Data source issue

Hi Team,

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.

 

Kindy help

2 REPLIES 2
ThisIsFalse
Resolver I
Resolver I

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? 

v-shex-msft
Community Support
Community Support

Hi @srlabhe123,

 

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

 

13.PNG

 

Reference links:

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.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors