Create dataset with live connect to AAS programmatically

[Eugene_Ov]

Hi everyone,

Is there any way to create a live connect dataset to Azure Analysis Services in Power BI workspace programmatically? When publishing a report with live connect to the Service, I see its dataset at app.powerbi.com, but it's not visible using XML/A endpoint, therefore I'm not able to create one because I don't know how to define it.

I've managed to create a connection using recently released DQ for AAS/PBI dataset functionality, however it's not what I'm looking for. I need strictly live connect dataset.

Eugene

[v-kelly-msft · Accepted solution]

Hi @Eugene_Ov ，

After checking the document,it is not supported currently.

Unsupported datasets

The following datasets aren't accessible by the XMLA endpoint. These datasets won't appear under the workspace in SSMS or in other tools:

• Datasets based on a live connection to an Azure Analysis Services or SQL Server Analysis Services model.

For the reference,see below:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!