Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
@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.
@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?
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.