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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
v-xiaoyan-msft
Community Support
Community Support

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

5 REPLIES 5
Clem_Fandango
Advocate II
Advocate II

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

v-xiaoyan-msft
Community Support
Community Support

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

 

Where i can track 360537118 ?

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.