RLS with PPU

[HFT]

I have a power bi ppu license and I want to embed a rls based report in our organisation web url.

Now I am working on client based report and should be able to make the RLS applied Embed url be worked in our web page and that to without incurring extra costing can I achieve it. If yes please let me know the approach.

[HFT]

Yes, Thank you for the response and would like to know how to automate the embed token generation for 50 users.

[v-aatheeque]

Hi @HFT ,

To automate the generation of embed tokens for 50 users in Power BI, you can use the Power BI REST API.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[HFT]

Hi,

Should I consider going with A1 sku capacity or Fabric F64 capacity for Integrating the power BI in our Organization app.

[v-aatheeque]

Hi @HFT ,

• If your main goal is to embed Power BI reports and dashboards directly into your app and you're looking for a cost-effective solution, the A1 SKU is a better choice. It's designed specifically for embedding scenarios and gives you the essential features you need without the extra overhead.
• On the other hand, if you're aiming for a more powerful analytics setup that goes beyond just reporting like handling complex data integration, leveraging AI, or deep data exploration—the Fabric F64 capacity might be a better fit. It’s built for scale and packed with advanced capabilities to support a wider range of analytics needs.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[HFT]

The Azure sales support team recommended using the F64 SKU instead of A1, stating that F64 is more cost-effective. They also mentioned that the A1 SKU will be phased out, and we will need to rely on Fabric capacities moving forward. This has left me uncertain about which license I should choose.

[v-aatheeque · Accepted solution]

Hi @HFT 

A1 SKU is part of the legacy Power BI Premium model, suited for basic workloads but with limited scalability and features. It offers lower upfront costs but is being deprecated. In contrast, the F64 SKU is part of the modern Microsoft Fabric platform, supporting unified analytics across Power BI, Lakehouse, and more. It delivers higher performance, better scalability, and improved cost efficiency.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[v-aatheeque]

Hi @HFT ,

Just looping back on your question abouta power bi ppu license and I want to embed a rls based report in our organisation web url. @Deku  @manikumar34 has shared some helpful input that might guide you in the right direction.If that response solved the issue, it would be great if you could mark it as the Accepted Answer  it not only closes the loop but also helps others who might be facing a similar situation.

If you're still unsure or need further guidance, feel free to drop us more details  we're here to help.

Thanks again for being part of the Microsoft Fabric Community!

[HFT]

Hi @v-aatheeque 

what if I have 50 users and i have Embed A1 capacity will that be enough or should I opt for more bigger capacity, please help

[v-aatheeque]

Hi @HFT ,
The suitability of Power BI Embedded A1 capacity for 50 users depends on factors like report complexity, dataset size, and how often users access the reports. A1 capacity offers 1 virtual core and 3 GB of RAM, making it suitable for lightweight use cases.

For 50 users, start with A1 only if usage is light. Upgrade to A2 or A3 if reports are complex or multiple users access concurrently.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[HFT]

PPU capacity in the sense, the RLS report should be either in Power BI Embedded (A-SKU) or (P-SKU) right? only with PPU we cannot integrate the RLS report in any public web application.

[v-aatheeque]

Hi @HFT ,

Yes you are right ,To integrate a Power BI report with RLS into a public web application, you must use Power BI Embedded (A-SKU) or Power BI Premium (P-SKU).
PPU supports RLS within the Power BI service but doesn’t provide the embedding capabilities for public web applications.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[v-aatheeque]

Hi @HFT ,
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[HFT]

Yes, I tried aquiring the Embed license and now I have the access token and got the Embed URL and Embed token, how should I integrate in in the front end to display the report with around 20 roles in RLS, please help

[HFT]

Hi Manikumar,

Please let me know how to use the Power BI javacsript as I am new to that concept. Suggest any related url to check online. 

[manikumar34]

Embed Power BI Reports Using JavaScript
🔗 https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-sample-for-customers

GitHub Repo for Power BI JavaScript SDK
🔗 https://github.com/microsoft/PowerBI-JavaScript

[Deku]

Since using PPU, it the report is backed by the PPU capacity, all report viewers will require PPU licences

[v-aatheeque]

Hi @HFT ,

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[manikumar34]

@HFT , 
Yes, it won't incur additional costs. You can use the Power BI JavaScript API (Power BI Client SDK) and use the Embed URL to acheive this.