Forum Discussion
GET requests with Web connector
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
3 Replies
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,
LydiaQuery 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 colorI 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.
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 colorI 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.
