topic Re: Query String Report Selection with Embedded in Developer

Query String Report Selection with Embedded

ats1958 — Thu, 19 Jul 2018 18:19:59 GMT

I would like to replace the report navigation at the bottom of Power BI Embedded with my own buttons and icons. Does anyone have a tutorial for this? My initial thought is that I could create each button, make each one a link to a URL with query string (www.mysite.com?report="Report1"), and somehow use this value in the JavaScript API. I'm open to any other implementation ideas as well.

Also, I'm using RLS, though I don't think that will affect anything.

Thanks!

Re: Query String Report Selection with Embedded

v-jiascu-msft — Fri, 20 Jul 2018 07:57:55 GMT

Hi @ats1958,

There are JS functions that can achieve your goal. Please try it in this site which also contains source code.

// Get a reference to the embedded report HTML element
var embedContainer = $('#embedContainer')[0];

// Get a reference to the embedded report.
report = powerbi.get(embedContainer);

// Retrieve the page collection, and then set the second page to be active.
report.getPages()
    .then(function (pages) {
        pages[1].setActive()
            .catch(function (errors) {
                Log.log(errors);
            });
    })
    .catch(function (errors) {
       Log.log(errors);
    });

Best Regards,

Dale

Re: Query String Report Selection with Embedded

v-jiascu-msft — Fri, 27 Jul 2018 09:21:02 GMT

Hi @ats1958,

Could you mark the proper answer as a solution please?

Best Regards,

Dale