Power Automate Power BI Scheduled report can not read data from second Data Model (Semantic Model)

[abksharma]

My Power BI report has two data sources from two different workspaces. Part 1 (Section 1) of report renders fine, But when I use second semantic model for report from a different workspace. Power Automate fails to render the report.

• Power BI Report Part 1: renders fine (workspace 1)
• Power BI Report Part 2: Error (workspace 2, no rendering)

Error does not show up, I don't have access to power bi server logs or Power Automate logs.

originally asked here
https://stackoverflow.com/questions/78976361/power-automate-power-bi-scheduled-report-can-not-read-d...

Thanks 
ABK

[abksharma · Accepted solution]

The issue was fixed by using right power automate request. passing correct identity values in request.

Correct power automate Request for multiple dataset with RLS:

Correct power automate Request for multiple dataset with RLS: 
{
    "host": {
        "connectionReferenceName": "shared_powerbi",
        "operationId": "InitiateExportToFileForPbiReports"
    },
    "parameters": {
        "groupid": "workspace GUID",
        "reportid": "workspace GUID",
        "ExportPayloadPowerBIReport/format": "PDF",
        "ExportPayloadPowerBIReport/PowerBIReportExportConfiguration/identities": [
            {
                "username": "testuser@abk.com",
                "datasets": [
                    "dataset 1 guid",
                    "dataset 2 guid"
                ],
                "roles": [
                    "RLS ROLE 1",
                    "RLS ROLE 1"
                ]
            }
        ]
    }
}

[abksharma]

Flow user is me and I have created both workspaces and I am the admin of the workspaces. They are in premium capacity.

[lbendlin]

That's nice but not what I mean.  Did you install both apps?

Does it work with a single (not composite) semantic model?

[abksharma]

Sorry if I am missing on something, I have not used any Power BI App feature,

But both have RLS and access enabled. I am running automate flow using my creds which have all access. 

[lbendlin]

The flow user needs to have registered/installed both Power BI apps.