Forum Discussion

abhi123's avatar
abhi123
Frequent Visitor
10 years ago

embed filter issue

 

Hello,

 

I am finding difficulty in applying the filter through embed javascript api.

 

I have two companies, i.e. 'abc' and 'xyz', I want to apply filter on companyname with 'abc'.

 

I tried below code but it does not apply filter, can anybody help !!!

 

Thanks in advance........

 

          var filterTypeTarget={};
	  var operatorAndValues={};
	  
	  filterTypeTarget.table = 'companytable';
	  filterTypeTarget.column = 'ComapnyName';
	  
	  operatorAndValues.type='basic';
	  operatorAndValues.operator = 'In';
	  operatorAndValues.values = ['abc','xyz'];
	  
	  values = ['abc'];
	  
	  
	  $(function () {
	  
		 var models = window['powerbi-client'].models;
		 var defaultFilter = new models.BasicFilter(filterTypeTarget, operatorAndValues, values);
		  
		  console.log(defaultFilter.toJSON());
		  
		  var report;
		  var embedConfiguration = {
			type: 'report',
			filter: defaultFilter.toJSON(),
			.
			.
			.
			.
			embedUrl: 'https://embedded.powerbi.com/appTokenReportEmbed'
	};
	
		var $reportContainer = $('#reportContainer');
		report = powerbi.embed($reportContainer.get(0), embedConfiguration);
         })

 

 

 

10 Replies

      • Sunkari's avatar
        Sunkari
        Icon for Responsive Resident rankResponsive Resident

        abhi123: Is Javascript api works with Rest API? 

        We have integrated our reports in an external application using Rest API(Not Power BI Embedded azure) so we want to customize integration process using Javascript API.