Skip to main content
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

Regular Visitor

Failed to make a XLMA call to a PowerBI (SASS) dataset

I have the role of Fabric Adminstrator and trying to make a xlma api call through powershell. The folloing is the my scripts: 


Install-Module -Name SqlServer -Scope CurrentUser

$cred = Get-Credential

$XmlaCommand = @"
    <Discover xmlns='urn:schemas-microsoft-com:xml-analysis'>
                <DatabaseName>Job Monitoring</DatabaseName>

Invoke-ASCmd -Credential $cred -Server "powerbi:// > ACE Development TEST" -Database "test" -Query $XmlaCommand


And I have the following error: 

Invoke-ASCmd: A connection cannot be made. Ensure that the server is running.


Please advice 

Super User
Super User

Hi @Boji ,


Did you already try URL encoding your server URL? Instead of 

"powerbi:// > ACE Development TEST"







Hi Martin,

I have some additional information regarding the error. I attempted to connect to the workspace above with Tabular Editor, which is another way to test if I have access to the XMLA endpoint of the workspace. Unfortunately, I was unsuccessful. Please see the screenshot below for the error message.

In addition, I found a note in the workspace settings that reads “This workspace is configured to use a capacity you don’t have access to.” Could this be triggering the error since I don’t have access to the premium workspace? Currently, I work as a fabric administrator role in my company with premium capacity licenses. What role do I need to connect to those XMLA endpoints?


Screenshot 2023-10-31 3.pngScreenshot 2023-10-31 2.png

Good morning Martin: 


After I tried to using URL encoding I still have the same error: Invoke-ASCmd: A connection cannot be made. Ensure that the server is running.


From a video I watched online for XLMA on youtube My understanding is that the workspaces SASS instances act as servers the XLMA protocle tries to connect to.  Is this possible that there is something wrong with SASS instance settings? How can I check if XLMA endpoints are available in a different way? 


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.