How to retrieve Slicers Data prom power BI report

Neehar — Wed, 25 May 2022 16:34:56 GMT

Hello,

I want to retrieve the Slicers data in a power bi report from all the pages.

I tried the below code, which is provided in the url getSlicers()

page.getSlicers() .then(slicers => { debugger console.log(slicers); });

I thrown an error Uncaught (in promise) TypeError: page.getSlicers is not a function.

Please help me with a working example.

Thank You

Re: How to retrieve Slicers Data prom power BI report

Anonymous — Mon, 30 May 2022 02:27:56 GMT

HI @Neehar,

I'd like to suggest you test on the power bi playground, it shared the sample report and corresponding code snaps of each operation:

Power BI Playground - Developer Sandbox

// Retrieve the page collection and get the slicers for the active page. try { const pages = await report.getPages(); // Retrieve the active page. let pageWithSlicer = pages.filter(function (page) { return page.isActive; })[0]; const visuals = await pageWithSlicer.getVisuals(); // Retrieve all visuals with the type "slicer". let slicers = visuals.filter(function (visual) { return visual.type === "slicer"; }); slicers.forEach(async (slicer) => { // Get the slicer state. const state = await slicer.getSlicerState(); console.log("Slicer name: \"" + slicer.name + "\"\nSlicer state:\n", state); }); } catch (errors) { console.log(errors); }

Regards,

Xiaoxin Sheng

topic How to retrieve Slicers Data prom power BI report in Developer

How to retrieve Slicers Data prom power BI report

Re: How to retrieve Slicers Data prom power BI report