Pass List of Parameter or when user select from Power BI ID passed into the API to get the Details

[Singh_10]

Hi,

I want to pass the parameter into the API URL in Power bi to fetch the details of USage report

= OData.Feed("https://reports.office.com/pbi/v1.0/" & TenantID,null,[ODataVersion=4])

TenantID would be the list of parameter or when user select the tenent ID to get the details

[v-xinruzhu-msft]

Hi @Singh_10 

1.As @lbendlinmentioned, the OData not supports direct query mode,  so if you want to implement it , you consider to create a paramater, then input related information to filter tenant ID. e.g you use the  username to filter the id, you can create a paramater called username, set it type to text.

The  in the tenantid table, filter the table with the paramater.

Then change the code of the url to the following.

= OData.Feed("https://reports.office.com/pbi/v1.0/" & TenaneID[TenantID]{0},null,[ODataVersion=4])

You can edit the paramater in Data Settings Power BI Service  or in Power query editor.

2.You can consider to put the data to SQL Server and use direct query mode to connect it so that you can use dynamic paramaters.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Singh_10]

Hi @v-xinruzhu-msft  thank you for the response i will implement this and update this post 

[lbendlin]

Are you expecting this to be refreshable on the service?

[Singh_10]

yes , refreshable when user select from the filter

[lbendlin]

Well, that's a separate issue, and one you cannot solve with the standard ODATA connector, as it doesn't even support Direct Query.