Forum Discussion

Eugene_Ov's avatar
Eugene_Ov
Helper I
5 years ago
Solved

Create dataset with live connect to AAS programmatically

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

  • 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!

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    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!