topic Re: MSBI Retrieve Filters and Selected Categories (Values) in Filters in Report Server

MSBI Retrieve Filters and Selected Categories (Values) in Filters

Anonymous — Tue, 13 Dec 2022 12:13:50 GMT

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

Re: MSBI Retrieve Filters and Selected Categories (Values) in Filters

v-luwang-msft — Wed, 14 Dec 2022 08:34:23 GMT

HI Anonymous ,

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

Best Regards

Lucien

Re: MSBI Retrieve Filters and Selected Categories (Values) in Filters

Anonymous — Wed, 14 Dec 2022 09:15:45 GMT

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