CODEWITHSUNDEEP
powerbipower-automate
abksharma
abksharma

Reputation: 598

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

My Power BI report has two data sources from two different workspaces. Part 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.

enter image description here

Upvotes: 0

Views: 50

Answers (1)

abksharma
abksharma

Reputation: 598

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

enter image description here

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": "[email protected]",
                "datasets": [
                    "dataset 1 guid",
                    "dataset 2 guid"
                ],
                "roles": [
                    "RLS ROLE 1",
                    "RLS ROLE 1"
                ]
            }
        ]
    }
}

Upvotes: 0

Related Questions