You plan to create a Power BI report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root. The OData feed…

This question tests your ability to use Power BI parameters to abstract an OData service root URL, so that when the feed's location changes, only one value needs to be updated rather than modifying each query individually.

Query and transform data

Question

You plan to create a Power BI report that will use an OData feed as the data source. You will retrieve all the entities from two different collections by using the same service root. The OData feed is still in development. The location of the feed will change once development is complete. The report will be published before the OData feed development is complete. You need to minimize development effort to change the data source once the location changes. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Explanation

Approach. The correct three-step sequence is: (1) In Power BI Desktop, create a query parameter (e.g., 'ServiceRoot') to hold the OData base URL. (2) Build both OData collection queries referencing that parameter as the service root - both entity collections share the same parameter, so neither query hardcodes the URL. (3) Publish the report to Power BI Service. When the feed location changes after development, you update only the single parameter value (either in Desktop or via Power BI Service dataset settings), and both collection queries automatically point to the new root - this is the minimum-effort change path. Without a parameter, you would have to open and edit every affected query manually, multiplying the effort proportionally to the number of queries.

Concept tested. Power BI query parameterization for dynamic data source management - specifically using a shared base-URL parameter for OData feeds to decouple query definitions from environment-specific connection strings, enabling single-point updates when source locations change.

Reference. Microsoft Learn: 'Create and use parameters in Power BI Desktop' and 'OData feed connector in Power BI' - covers parameterizing data source URLs and updating parameters post-publish via dataset settings in the Power BI Service.

Topics

#Power Query Parameters#Data Source Management#OData Feed#Data Source Reusability

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice