Forum Discussion
Direct Query not supported with V1 embed token
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
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.
4 Replies
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.
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.