Error when embedding a report with a DirectQuery connection to a Power BI dataset

[hectormolinero]

Hi all,

I'm trying to use Power BI Embedded to embed a report containing a DirectQuery connection to a Power BI dataset and I get the following error when viewing the report:

The lineage view is the following:

I'm obtaining the embedded token by sending the following JSON to the GenerateToken endpoint:

{
  "datasets": [
    { "id": "XXXXXXXX-0000-0000-0000-000000000000" },
    { "id": "YYYYYYYY-0000-0000-0000-000000000000" }
  ],
  "reports": [
    { "id": "ZZZZZZZZ-0000-0000-0000-000000000000", "allowEdit": false }
  ],
  "identities": [
    {
      "datasets": ["XXXXXXXX-0000-0000-0000-000000000000"],
      "username": "example",
      "roles": ["example"]
    }
  ]
}

After some research I've found that using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI dataset or Azure Analysis Services model is not currently supported.

I would like to know if this is indeed the problem I'm experiencing and if so, if and when this feature is planned to be added.

Best regards,

Héctor.

[v-easonf-msft · Accepted solution]

Hi, @hectormolinero 

As of now, using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets or Azure Analysis Services model is not yet supported.  PowerBI team plan to support this as soon as possible and not sure about the ETA. You can refer to  2021 release wave 1 plan .

The functionality "DirectQuery for PBI datasets and AS" is currently in preview. If you have any other questions about the Preview feature , feel free to leave feedback at this Power BI Community forum post .

You can also  subscribe to the Power BI Blog. PowerBI team will mention it in the monthly blog and update the dedicated blog and docs as well.

Best Regards,
Community Support Team _ Eason

[arpost]

@v-easonf-msft, does this limitation also apply in cases where the embedding is happening using Power BI Premium with a P1 SKU?!