topic Re: iframe embedding code to filter data by customer in Developer

iframe embedding code to filter data by customer

MaxItaly — Wed, 06 Sep 2017 09:01:26 GMT

Hello everyone,

I'm not very accostumed to the embedding of a report via the iFrame code that is generated by Power BI when you click on "Publish to web", so I'd like to ask if what I'd like to is possible, or not.

These are my presuppositions:

let's say that I have a site where customers can log-in, and customers don't have a Power BI account. but I have a Pro account.

I'd like to publish a report on my site that shows filtered results (let's say, customers = "Customer A") depending on the customer who logged in (i.e. the customer only sees his data).

I am quite sure that this is achievable, but not with my presuppositions.

1) This configurations implies an "App owns data" configuration, right (and the use of "Power BI Embedded")?
2) And this would therefore imply that I'd need to own a Premium Account to do such a thing?

3) With an "User owns data" configuration, every customer would need a Power BI pro account (and I'd need to use REST APIs)?

Thanks to everyone who can give me an hint about this.

Re: iframe embedding code to filter data by customer

Eric_Zhang — Thu, 07 Sep 2017 02:36:41 GMT

@MaxItaly wrote:

Hello everyone,

I'm not very accostumed to the embedding of a report via the iFrame code that is generated by Power BI when you click on "Publish to web", so I'd like to ask if what I'd like to is possible, or not.

These are my presuppositions:

let's say that I have a site where customers can log-in, and customers don't have a Power BI account. but I have a Pro account.

I'd like to publish a report on my site that shows filtered results (let's say, customers = "Customer A") depending on the customer who logged in (i.e. the customer only sees his data).

I am quite sure that this is achievable, but not with my presuppositions.

1) This configurations implies an "App owns data" configuration, right (and the use of "Power BI Embedded")?
2) And this would therefore imply that I'd need to own a Premium Account to do such a thing?

3) With an "User owns data" configuration, every customer would need a Power BI pro account (and I'd need to use REST APIs)?

Thanks to everyone who can give me an hint about this.

@MaxItaly

For "Publish to web", you can't append a filter parameter to the report url. Your understanding is right, for the customers who have no Power BI accounts, Embedding with non-Power BI users (app owns data) is definitely for this scenario. You need a Premium licence. As to showing filtered result, either using Power BI Javascript Filter or the securable approach Row Level Security.

Re: iframe embedding code to filter data by customer

MaxItaly — Thu, 07 Sep 2017 07:08:46 GMT

I really hoped there was an alternative solution...

Thanks for confirming my point, which I was not sure about it.

Re: iframe embedding code to filter data by customer

Rachita — Mon, 16 Apr 2018 09:28:58 GMT

Hi,

I have the same doubt as yours.
Were you able to find a solution to your problem?

Re: iframe embedding code to filter data by customer

MaxItaly — Mon, 16 Apr 2018 09:35:18 GMT

Hi,

with a Pro license that is impossible.

You need a premium license to do that (and several different skills from the simple report making).

Luckily, what wanted to achieve wasn't a must for my business, so we didn't do that in the end.

I am afraid there is still not a Pro solution to this problem.

Re: iframe embedding code to filter data by customer

Rachita — Mon, 16 Apr 2018 09:47:43 GMT

Okay.
Thank you very much.