Forum Discussion
ODATA service URL as dynamic parameter
- 1 year ago
Hi AmarishJayanth
Thanks for reaching out to the Microsoft fabric community forum.
you can create a parameter in power query, then set the parameter with slicer, you can refer to the following link.Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
The following sample cannot allow the user to input the parameter, if you want to edit the parameter to change the filter, you can only do it in power query or edit it in data source setting when the report is published to Service, you can refer to the following link.
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
Sample data
Step1: Create a parameter in power query
Step 2: Modify the ODATA Service URL:
Open Power Query Editor by navigating to the "Home" tab and clicking on "Transform Data".
Locate the query which retrieves data from the ODATA service.
In the query, replace the static date in the ODATA service URL with the parameter you create. For example:let
Source = OData.Feed("https://your-odata-service-url?date=" & Date.ToText(SelectedDate, "yyyy-MM-dd"))
in
Source
Step3: Load the Data- Close and apply the changes in the Power Query Editor.
- The data will now be filtered based on the selected date in the slicer.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hope this will help.
Thank you.
Good Day to the experts,
The scenario is I want to extract the OData form SAP and I would like to ask that the source URL is required for username and password.
Since the Username and password is keyed correct but there is an error shows we couldn't authenticate this, how can I solve for this?
Also the same URL is works well if using connection string in Excel only, but not in the power query.
Thank you for the time.