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: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

monaraya
Microsoft Employee
‎07-21-2020 05:55 AM

Unable to Connect to Power BI Through XMLA Endpoint Using SQL Profiler

I have worked on an issue where one of the customers was unable to connect to Power BI through XMLA endpoint using SQL Profiler.

The error message looks like below:

Error XMLA.png

To overcome this error, follow the steps below:

  • Open SQL Profiler, select Authentication method as 'Azure Active Directory - Universal with MFA'

XMLA Authentication mode.jpg

  • Make sure you enter the database name in connection properties and add Database name under ‘Connection Properties’ tab(Specify a dataset (database) in your workspace. In the Connect to Server dialog, click Options > Connection Properties > Connect to database, enter the dataset name).

XMLA Connection Properties.png

  • Make sure to enable XMLA endpoint in 'Read Write' mode and have access to database/dataset that was specified in previous point.
    1. In the Admin portal, click Capacity settings > Power BI Premium > Capacity name.
    2. Expand Workloads. In the XMLA Endpoint setting, select Read Write.

XMLA Read Write Admin Portal.png

 

Author: Srishti Sharma

Reviewer: Mounika Narayana Reddy