OData $Batch usage in powerbi

[JoeHaySPGI]

Hi, I'm looking to implement an odata service which will need to expose some datasets using OData's $batch option.

How can we setup power bi to use the $batch option to request all pages of a dataset in a single request?

cheers,

Joe

[v-stephen-msft · Accepted solution]

Hi @JoeHaySPGI ,

One possible option I can think of is using Parameters. 

Parameters are something you can define in the Query Editor and use it within your queries in the query editor.

If you want to pass value, you can try to set a parameter from power queries in power bi desktop and you can also use it after publishing to service under dataset settings.

You can refer the following microsoft blog and document that could also help you:

1. Parameters - Power Query | Microsoft Learn
2. Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...
3. How to Configure Data Source Setting Parameters for a Power BI Data Model - Microsoft Dynamics CRM C...

Best Regards,

Stephen Tao

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