Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

deepti_mrl

error message:Cannot connect to dataset with embed token because XML bcos XMLA permissions are off

Submitted by on ‎09-12-2022 11:17 PM

Objective: To embed a PBI report on a portal where the report does not require authentication or sign-in to PBI.

Have tried the below:

 

  • Verified the report works directly inside the Power BI service
  • Verified I can connect via XMLA to the composite model (XMLA read-write access provided)
  • Ensure the service principal used by the embed application has access to both datasets 
  • Ensure the service principal used by the embed application has access to both workspaces (member access)

The dataset is a composite model. The .NET code works if the dataset ID is not provided. Please share ramifications of not including the dataset ID in the code.

Please help resolve this issue.

Status: Investigating

Hi @deepti_mrl,

 

To access content including datasets in Power BI service, you need the identify id to state the specific content you are accessing. And to access the specific content, you must have required permissions and during the access Power BI will acquired token for the specific content and access with it.

 

For something related to connect to dataset with XMLA endpoint, you could have a look at this official document. Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

 

Best Regards,    

Community Support Team _ Caiyun

See more ideas labeled with:
2 Comments (2 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎09-13-2022 08:12 PM
Status changed to: Investigating

Hi @deepti_mrl,

 

To access content including datasets in Power BI service, you need the identify id to state the specific content you are accessing. And to access the specific content, you must have required permissions and during the access Power BI will acquired token for the specific content and access with it.

 

For something related to connect to dataset with XMLA endpoint, you could have a look at this official document. Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

 

Best Regards,    

Community Support Team _ Caiyun

Idea Statuses