Standard JSON data, either from a file or web url
I am using Power BI and Excel through Power Query with a JSON API with two separate data providers. The functionality that doesn't exist is being able to pass M Parameters into Power Query with JSON. M Parameters only work with Direct queries and JSON is an Import type. Being able to provide a user interface where a pick list can be used that then execute the query would be immensely powerful. I agree with one other comment in this post regarding the documentation. It is really difficult to figure out the syntax for a JSON API call in Power Query.
