Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 "Embeddi...
Need Help
Tips and Tricks
  • AmosHersch's avatar
    AmosHersch
    4 years ago

    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.

     

AmosHersch's avatar
AmosHersch
Microsoft Employee
4 years ago

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.

gnico's avatar
gnico
Regular Visitor
3 years ago

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.