Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
HI @Anonymous ,
Could you pls share your sample data and expected output result, remember to remove confidential data.
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |