We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
How to post a commmand in M-Query editor for Rest API
I can run normal SQL like this
http://ip:port/command/dbname/sql/select%20%20from%20V
But I would like to run command like this
http://ip:port/command/dbname/sql/{ "command": "select from V where name = ? and city = ?",
"parameters": [ "Luca", "Rome" ]
}
You can make a table with two columns for your parameter values and then concatenate them into your sql function in a custom column. You will then get a column of tables with the results you can expand and combine.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 7 | |
| 5 |