iframe embedding code to filter data by customer

[MaxItaly]

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.

[Eric_Zhang · Accepted solution]

---

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

[MaxItaly]

I really hoped there was an alternative solution...

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

[Rachita]

Hi,

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

[MaxItaly]

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.

[Rachita]

Okay.
Thank you very much.