topic Direct Query not supported with V1 embed token in Developer

Direct Query not supported with V1 embed token

Anonymous — Wed, 13 Jul 2022 07:05:39 GMT

Hi,

I have a power automate flow that uses "Export to file for Power BI Reports" action with defined Identities (Username, Role and Dataset). When I trigger the flow, it returns an error "Embedding a report with a model which has a Direct Query connection to another model is not supported with V1 embed token". The report being exported is using a composite model with import and direct query combined. This error only occurs when Identities is in place, otherwise, it runs successfully. Does anyone know a work around for this?

Cheers

Re: Direct Query not supported with V1 embed token

AmosHersch — Wed, 13 Jul 2022 11:03:39 GMT

Hi @Anonymous ,

Exporting a report with a model with DirectQuery to another model with effective identity isn't currently supported.

I don't think this limitation is documented as this is pretty advances scenario.

As far as I know it should be supported sometime soon, but I can't guarantee when.

Re: Direct Query not supported with V1 embed token

Anonymous — Wed, 13 Jul 2022 23:37:48 GMT

Hi Amos,

Is there any other workaround we can apply in the Power BI or Power Automate side, just so we can incorporate RLS?

Re: Direct Query not supported with V1 embed token

AmosHersch — Thu, 14 Jul 2022 07:41:09 GMT

Hi,

Power BI API doesn't support it, and I don't know of any possible workaround.

The Power Automate is just a wrapper to allow calling the Power BI API as part of a flow, so it can't help in that matter.

Re: Direct Query not supported with V1 embed token

gnico — Wed, 25 Jan 2023 11:50:39 GMT

I have just came upon this post because I got the same error message and actually, there is a solution for this. You can achieve this using this method instead:

https://learn.microsoft.com/en-us/rest/api/power-bi/embed-token/generate-token

There a specific usecase that is exactly what you need:

Example of generating an embed token for two datasets with RLS identities and a single report with read-only permissions. The embed token lets you view the report, which is dynamically bound to two different datasets.