Semantic layer design and row level security with third party access - best practice

Hi po,

I have a little confused about your scenario.

If I understand your requirement correctly that you want to know which is the best practice for modeling in Power BI or Sql Server Analaysis Services?

If it is, I'm afraid that should be determined by your specific requiremnt. Normally, the data modeling in SSAS will be more complex than that in Power BI. If you're not familiar with SSAS, I'll suggest you use Power BI design and configure the Row level Security.

In addition, you also could refer to this video Deep dive into data modeling using Power BI desktop and SQL Server Analysis Services to understand it in more details.

Please note if you use SQL Service Analysis Service as data source, you should create RLS in SSAS.

Best  Regards,

Cherry