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
theodosia
Frequent Visitor

Cannot select a gateway datasource in a dataset

Hello, 

I have a gateway installed and running and i have already used it for several schedule updates.

 

I have a report and i would like to add the Gateway connection. The data sources include on-premise (sqlserver) and SharePoint (online) data.

For the on-premise SQL server, i already have the data source in the gateway, so everything is fine. The field "Maps to" is enabled.

 

For the SharepointList, I click "Add to gateway". I create the new datasource everything is fine with the status online.

 

theodosia_0-1673601533670.png

Going back to the specific report datasource -> Settings-> Gateway connection still says "Add to gateway" I cannot select it. In addition, Apply button is disabled, so i cannot even apply the changes for the onpremise SQL server. 

What's the problem?

theodosia_0-1673602429829.png

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @theodosia ,

 

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:360537118 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

 

 

Best regards.
Community Support Team_ Caitlyn

 

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi, 
We're having the same issue which is preventing us from putting new reports into production.
I'll monitor this thread for updates.

Anonymous
Not applicable

Hi @theodosia ,

 

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:360537118 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

 

 

Best regards.
Community Support Team_ Caitlyn

 

Hi,
We still have this issue but the difference is we are trying to connect a ODBC driver from a gateway.

Lars_Gevers_0-1747144447783.png

As you can see above, the datasource is there (ODBC 2) which is connected to Gateway cluster "SLINGERLAND_SCREEN".
However if we go to our settings page and try to map it, the "map to" field stays empty

Lars_Gevers_1-1747144529916.pngLars_Gevers_2-1747144544625.png

 

Where i can track 360537118 ?

Anonymous
Not applicable

They have put an update on the PowerBI status page:
Support | Microsoft Power BI

stating
"Power BI customers using SharePoint list as a data source may see the "Apply" button greyed out in Gateway connection settings. Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 01/24/2023."

Hello

we are Wednesday already ? is there any update ?

this is preventing us for publishing and regreshing any reports combining sharepoint online source with on prem source

 

is there at least a turnaround identified?

 

thanks

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.