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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amos, 

 

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

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.