topic Re: embed filter issue in Developer

embed filter issue

abhi123 — Thu, 27 Oct 2016 12:46:41 GMT

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);
         })

Re: embed filter issue

KumarDarmesh — Fri, 28 Oct 2016 10:06:18 GMT

Is this the Power BI javascript api?

Re: embed filter issue

abhi123 — Fri, 28 Oct 2016 10:23:18 GMT

Yes it is..........

Re: embed filter issue

Sunkari — Fri, 28 Oct 2016 10:29:29 GMT

@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.

Re: embed filter issue

abhi123 — Wed, 02 Nov 2016 09:23:22 GMT

Hi Sunkari

I have used Azure powerbi embedded.

Can u please tell me the process of extrenal web api for the same(Without Azure)?.........

Thanks.

Abhi

Re: embed filter issue

Sunkari — Fri, 04 Nov 2016 06:59:10 GMT

@abhi123: Please go through the following link so that you will get some context about POWER BI Rest API

https://msdn.microsoft.com/en-us/library/dn877544.aspx

Note: Power BI rest API only supports single filter with single value.

Re: embed filter issue

abhi123 — Fri, 04 Nov 2016 07:39:35 GMT

Hi @Sunkari

Thank you so much for the same will go threw with that and will let you know.

Thanks

Abhi.

Re: embed filter issue

abhi123 — Wed, 09 Nov 2016 12:45:39 GMT

hi @Sunkari

Can you please provide one running demo on powerbi javascript api if possible?......really stuck on this.....!!

If you can then please.

Thanks

Abhi.

Re: embed filter issue

Sunkari — Wed, 09 Nov 2016 13:21:57 GMT

@abhi123: Sorry Man. I don't have that if found any it. Please share with me

Re: embed filter issue

abhi123 — Wed, 09 Nov 2016 13:33:41 GMT

No issues.

Thanks

Abhi.

Re: embed filter issue

LeslieCUy — Wed, 09 Nov 2016 23:19:00 GMT

In your embedConfiguration, is "filter" or "filters" (with an 's')?

Per the documentation, I believe it is filters.

Also, it should be an array i.e., filters: [ defaultFilter.toJSON() ]

Please give it a try and let me know because I too am having issues setting the filters in the embeddedConfiguration. I get the following errors in the console

https://wabi-us-north-central-redirect.analysis.windows.net/powerbi/metadata/models Failed to load resource: the server responded with a status of 401 (Unauthorized)

embed.ts:168

Uncaught

Array[3]

0:Object

message:"filters is invalid. Not meeting type constraint"
__proto__:Object

1:Object

message:"filters is invalid. Not meeting type constraint"
__proto__:Object

2:Object

message:"filters property is invalid"
__proto__:Object

length:3
__proto__:Array[0]