Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shwetak
Frequent Visitor

Power BI Embedded

I have published report & embedded it in my HTML snippet. which works fine at the initial level. data loads perfectly. Getting issue when trying to apply filters on it.

Below is my code,

 

<script>
		var txtAccessToken = 'eyJrIjoiOTQ2OWMzMTgtODdlMi00YTlmLTljYjUtYTc2MDcxYmM2ZDUxIiwidCI6IjhhZDJkNjdmLWY4NjQtNDkzZi1iN2I5LWI2ODEzODU0N2JlMSJ9';
		var txtEmbedUrl = 'https://app.powerbi.com/view?r=eyJrIjoiOTQ2OWMzMTgtODdlMi00YTlmLTljYjUtYTc2MDcxYmM2ZDUxIiwidCI6IjhhZDJkNjdmLWY4NjQtNDkzZi1iN2I5LWI2ODEzODU0N2JlMSJ9';
		var txtEmbedReportId = 'ae9dba68-2335-47e5-bd25-f733d76803bc';
		 
		var models = window['powerbi-client'].models;
		var permissions = models.Permissions.All;
		
		var config= {
			type: 'report',
			accessToken: txtAccessToken,
			embedUrl: txtEmbedUrl,
			id: txtEmbedReportId,
			permissions: permissions,
			settings: {
				filterPaneEnabled: true,
				navContentPaneEnabled: true
			}
		};
		 
		
		
		var reportContainer = $('#reportContainer')[0];
		var report = powerbi.embed(reportContainer, config);
		
		 const filter = {
			  $schema: "http://powerbi.com/product/schema#basic",
			  target: {
				table: "Query1",
				column: "id"
			  },
			  operator: "In",
			  values: [80]
		};
		var reports = powerbi.embeds[0];
            if (reports) {
                reports.setFilters([filter])
                    .then(function (result) {
                        console.log(result);
                    })
                    .catch(function (errors) {
                        console.log(errors);
                    });
            }
 </script>

 

Thanks in Advance, Let me know what I am missing. 

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft Employee
Microsoft Employee

@shwetak

Your code looks good. I can reproduce the same issue at the moment I post.

I've consult internally and it turns out a known issue, the product team is working on a fix. Thanks for your reporting and patience. 🙂

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee

@shwetak

Your code looks good. I can reproduce the same issue at the moment I post.

I've consult internally and it turns out a known issue, the product team is working on a fix. Thanks for your reporting and patience. 🙂

oh ok, 

 

Thanks for updating 🙂 Hope it will get resolved early. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.