GET requests with Web connector

[AleksShot]

Dear community,

We want to query our database via a REST API and display results in Power BI, but cannot find the right data source. Users should be able to:

- authenticate with credentials

- define GET URL parameters in a UI (custom-made by us)...

- ..and send off the request to pull data into Power BI

We made a custom UI with a login field and dropdowns to define GET parameters in Tableau, but is it also possible to do in Power BI? 

Thanks a lot in advance for your response! 

Have a great day,

Alex

[v-yuezhe-msft]

@AleksShot,

You are able to define data source parameter in Power BI Desktop. Please review the following blog and similar thread to get details.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072

If you don't get expected result by using parameter, please elaborate your requirement.

Regards,
Lydia

[QbsSnap]

Query Parameters looks promising. There's option to get form-like way to provide query params.

I'm able to define QP with Power Bi Desktop it self.
But I didn't find a way to predefine QP using PowerQuery (https://github.com/Microsoft/DataConnectors).
I'd like to develope custom connector and provide "ready to go" Queries with predefined Query Parameters.
Is there any way achieve this?

Easy example what I want to achieve with Power BI (but right now I se no option):
Use case: We want NON TECHNICAL user, with skill to use Power Bi to fetch data about toys (of given color) with our custom connector.
In our system we have two endpoints:
1. GET api/toy/colors - get every toy color
2. GET api/toys/{color} - get toys with given color

I know that I need to provide 2 queries: one for fetch color list and one for fetch toys data.

But in case of more parameters I want to provide simple form for the user to alow him 'plug and play' my connector.

[QbsSnap]

Query Parameters looks promising. There's option to get form-like way to provide query params.

I'm able to define QP with Power Bi Desktop it self.
But I didn't find a way to predefine QP using PowerQuery (https://github.com/Microsoft/DataConnectors).
I'd like to develope custom connector and provide "ready to go" Queries with predefined Query Parameters.
Is there any way achieve this?

Easy example what I want to achieve with Power BI (but right now I se no option):
Use case: We want NON TECHNICAL user, with skill to use Power Bi to fetch data about toys (of given color) with our custom connector.
In our system we have two endpoints:
1. GET api/toy/colors - get every toy color
2. GET api/toys/{color} - get toys with given color

I know that I need to provide 2 queries: one for fetch color list and one for fetch toys data.

But in case of more parameters I want to provide simple form for the user to alow him 'plug and play' my connector.