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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NoorAlfar
Frequent Visitor

Embedding report with multiple datasets(direct queries)

Hi,

 

Is it possible to embed a report with multiple datasets in direct query mode? the datasets and dataflows are located in 2 other workspaces with PPU licenses while the report is located in a third PPU workspace?

 

we are using the Microsoft sample code here

 

The error we're getting is :
"value": "Operation returned an invalid status code 'BadRequest' _ {\"error\":{\"code\":\"InvalidRequest\",\"message\":\"Cannot connect to
dataset xxxxxxxx with embed token because XMLA permissions are off\"}}"

 

How is the xmla related to this? any ideas on how to solve this

1 ACCEPTED SOLUTION
AmosHersch
Employee
Employee

Hi @NoorAlfar 

Please take a look at this example for generating an embed token with XmlaPermissions : Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn

View solution in original post

1 REPLY 1
AmosHersch
Employee
Employee

Hi @NoorAlfar 

Please take a look at this example for generating an embed token with XmlaPermissions : Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors