How to Create Embed report using Azure Logic apps for SSAS Cube Live connection with Roles defined

[gvrspk]

Hi All, 

I have a requirement to create Embed powerbi reporting using SSAS live connection as a source along with roles defined. 

1. in logic apps , while using HTTP i have tried below methods, 

"{

"accesslevel":"view",

"allowsaveas":"false",

"groupuseraccessrequest":"Role",

"Identifier":" ", 

"PrincipalType" : "App"

}" for this i got an error message like :  "Creating embed token for accessing dataset " " requires effective identity to be provided"

i tried to use below code 

"

{
"accesslevel": " View"
"identities" : [
{
"Username" : "Effective/identity",
"roles" : [" ", " "],
"customData" : ""
"datasets":[]
}
]
}" for this got an error : Resource access type View unsupported for Reports" 

i am new to this, can anyone help me to solve this issue. 

1. i hope for SSAS Live connection no need to create Roles in Powerbi reports , please confirm this. 

2. How to implement RLS in Embed report and how to pass custom data using logic apps. 

3. How to connect SSAS live connection using logic apps. 

Thanks in advance. 

[Anonymous · Accepted solution]

Hi @gvrspk ,

Please review the following links and check if they can resolve your problem.

1. i hope for SSAS Live connection no need to create Roles in Powerbi reports , please confirm this. 

Row Level Security with SSAS Tabular Live Connection in Power BI

2. How to implement RLS in Embed report and how to pass custom data using logic apps. 

Row-level security with Power BI Embedded

{
    "accessLevel": "View",
    "identities": [
        {
            "username": "EffectiveIdentity",
            "roles": [ "Role1", "Role2" ],
            "datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ]
        }
    ]
}

3. How to connect SSAS live connection using logic apps. 

Do you mean that refresh a Power BI Dataset using Azure Logic App? If yes, you can refer the following blogs to get it.

Refresh a Power BI Dataset using Azure Logic App

Best Regards