topic Re: Failed to make a XLMA call to a PowerBI (SASS) dataset in Developer

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

Boji — Tue, 31 Oct 2023 02:42:18 GMT

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 = @"

<RequestType>TMSCHEMA_PARTITIONS</RequestType>

<DatabaseName>Job Monitoring</DatabaseName>

</RestrictionList>

</Restrictions>

</Discover>

Invoke-ASCmd -Credential $cred -Server "powerbi://api.powerbi.com/v1.0/myorg/Admin > 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

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

Martin_D — Tue, 31 Oct 2023 06:58:57 GMT

Hi @Boji ,

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

"powerbi://api.powerbi.com/v1.0/myorg/Admin > ACE Development TEST"

try

"powerbi://api.powerbi.com/v1.0/myorg/Admin%20%3E%20ACE%20Development%20TEST"

Martin

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

Boji — Tue, 31 Oct 2023 13:14:01 GMT

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?

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

Boji — Tue, 31 Oct 2023 14:38:24 GMT

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?