Get Dataset Parameters from REST API for Direct Query Dataset

[navaraj]

I tried get the list of parameters using REST API as: https://api.powerbi.com/v1.0/myorg/groups/$group_id/datasets/$dataset_id/parameters" , but get the response as  empty array even though parameters are managed.

Result object(stdClass)#2 (2) { ["@odata.context"]=> string(98) "https://api.powerbi.com/v1.0/myorg/groups/$group_id/$metadata#parameters" ["value"]=> array(0) { } }

Case success for Import, but failed for Direct.

Does anybody get success in this parameters REST Api, please share your idea?  Thanks in Advance

[v-micsh-msft]

Hi,

I think the array is empty should be caused by the Parameter is not loaded into Data Model in Direct Query mode.

Once the Parameter is enabled load (Right click to enable load), then the query mode would switch to import mode.

For testing purpose, please take a try with a similar query under Import mode, remember to clear the Enable load to check.

Regards,

Michael