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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
NoorAlfar
Helper I
Helper I

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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