MSBI Retrieve Filters and Selected Categories (Values) in Filters

[Anonymous]

Hi,

I have to been trying to integrate PowerBI to my system. For which I need to retrieve a prebuilt report and a specific page of the report. Then get the filters and Tables (if exist) of the report modify it as per requirements and push the values to the powerBI report to show the modified results. I have tried the REST API provided by the PowerBI which doesn't have any retrieve/get filter api. Then I tried PowerBI Client React which has a getFilter and getSlicer functions associated with report and page. But whenever I call getFilter,  it always returns an empty array, even if the page has several filters. Can anyone please suggest me a possible solution for:

1. Retrieving all filters of a specific page of a report and the values that were selected by the user

2. Get the table(built as visual table) of that page if that page has any.

Thanks in advance

[Anonymous]

Hi @v-luwang-msft ,

Thanks for your reply.

For this screenshot for example, 

1. I want to get all the selected filters such as {Subclass1: [ALL], Subclass2: [DRILLING CONTRACT], Bkr Grp- Pol: [ALL]...}

2. Get the data of the table below or the table itselt (array or dataframe)

Kind Regards

[v-luwang-msft]

HI @Anonymous ,

Could you pls share your sample data and expected output result, remember to remove confidential data.

Best Regards

Lucien