Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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 

1 ACCEPTED SOLUTION
AmosHersch
Employee
Employee

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.

 

View solution in original post

4 REPLIES 4
AmosHersch
Employee
Employee

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
Not applicable

Hi Amos, 

 

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

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.

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 r... 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.