Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
RobinJackson
New Member

Unable to create connection to data source

Hi,

 

I'm trying to connect the data source with custom connector and on-premises data gateway. Here is the background:

 

I have created a custom connector which is used to send API requests and retrieve data from server. It passes some criteria such as table name, start year, end year, start month and end month. It also uses user name and password for user authentication. 

 

I installed on-premises data gateway (standard) and published a report from Power BI desktop. Now, I'm trying to setup schedule refresh for the report. 

 

I'm trying to add a new connection and select the connection type for my custom connector. I enter the criteria for retrieve data like table name and authentication details which are username and password. However, the following error message promots when I try to create a new connection:

 

RobinJackson_0-1701330015227.png

 

Here are the questions:

1. I'm using an admin account which is also the only account to do all the things and I'm using the only credential for authentication, so I'm sure I have permission to access the data source and the credentials must be correct. Why do I still see the error and what should I do?

2. I also tried to skip test connection, but I found that the data source path only contains string criteria (e.g. table name) but not number (e.g. start year, end month). Could it possibly be related?

 

I'm so confusing, so any suggestions or heads-up would be appreciated, thanks!

1 REPLY 1
lbendlin
Super User
Super User

PLease confirm that you installed the .mez on all gateway cluster members.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.