Power BI Exchange

Expand all | Collapse all

Work around for Azure Analysis Services Web Designer

  • 1.  Work around for Azure Analysis Services Web Designer

    Posted 3 days ago
    The other day I went to convert a large existing PBI file to an SSAS tabular model using the Azure Analysis Services Web Designer and was told the feature had been removed. Azure Analysis Services web designer to be discontinued | Azure updates | Microsoft Azure
    Microsoft remove preview
    Azure Analysis Services web designer to be discontinued | Azure updates | Microsoft Azure
    The Azure Analysis Services web designer in the Azure portal has been in public preview since it was introduced in July 2017. It was later deprecated in October 2018, meaning that it would be discontinued at some point in the future.
    View this on Microsoft >

    Short of re-creating my entire data mode in Visual Studio, I have not been able to find a solution like the Web Designer offered. Has anyone come up with any other alternatives? Dax Studio does not seem to do the same thing, and these models don't exist in Excel Power Query/Pivot to re-create from there either.

    Any help or experience anyone can offer would be appreciated!



    ------------------------------
    Mike Kromminga
    Data Architect
    ITA Group
    ------------------------------


  • 2.  RE: Work around for Azure Analysis Services Web Designer

    Gold Contributor
    Posted 3 days ago
    Hi @Mike Kromminga​,

    I am not sure if this will work or not, but have you tried looking into Dataflows.

    It was recently introduced in PBI to create a single data model and single point of distribution for the entire organization. You will probably need a Premium capacity or at least an A1 node for it. I'll try to check it and get back to you on that.

    I am not sure after creating one, if you will be able to transfer or use it as an SSAS tabular model, but you might want to have a look into that.

    My apologies, if my response is way off from what you are trying to do.

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------



  • 3.  RE: Work around for Azure Analysis Services Web Designer

    Posted 3 days ago

    Hi Mike,

    Try Tabular Editor. Currently it cannot replace SSDT 100%, but it's very good for modifying metadata like measures and display folders.


    During the SSAS Tabular development, I used SSDT for adding new tables and relationship, Tabular Editor for adding measures, and SSMS to delete Azure Analysis Services model if needed, plus DAX Studio for optimizing measures.

    Cheers,



    ------------------------------
    Leo Sugianto
    BI Developer
    Barfoot & Thompson
    Auckland
    ------------------------------