cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Erin001
Helper II
Helper II

gateway doesn't work with SQL server Stored procedure

The gateway option is greyed out on the Dataset settings window. A stored procedure is used to get the data from SQL server. Data connectivity mode is set as 'Impoort'.

 

Can anybody help?

 

thanks!

1 ACCEPTED SOLUTION

@Seth_C_Bauer@v-shex-msft

 

Thanks, and it works now. I changed the server of the connection on the desktop to match what is on the list of gateway setting while add the real server in the query.

View solution in original post

6 REPLIES 6

@Erin001 The datasource set up in the Service needs to match what you have set in the Power BI Desktop exactly. That is most likely the cause if you have no issues when running the report in the Desktop.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_BauerCould you tell me more about how to setup the datasource in the service to get the SP work? screenshot would be great. Thanks!

@Erin001 Which gateway did you deploy? Are you just executing a stored procedure or are you trying to pass a parameter?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauerpublic gateway, just a Sp without paramter...

Hi @Erin001,

 

What connection mode you use? If you mean 'direct query', current you can invoke stored procedure in power query, but it not works on direct query mode.

 

Regards,
Xiaoxin Sheng

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

@Seth_C_Bauer@v-shex-msft

 

Thanks, and it works now. I changed the server of the connection on the desktop to match what is on the list of gateway setting while add the real server in the query.

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors