topic Get Dataset Parameters from REST API for Direct Query Dataset in Developer

Get Dataset Parameters from REST API for Direct Query Dataset

navaraj — Thu, 15 Mar 2018 08:54:57 GMT

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 — Mon, 19 Mar 2018 06:09:30 GMT

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