Skip to main content

    Power BI

    Completed

    Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    Vote (14) Share
    Ralf Schou-Jensen's profile image

    Ralf Schou-Jensen on 07 Oct 2015 17:07:53

    Like the live connetion for tabular models it would be nice to have the same for SSAS Cubes/multidimensional instead of having toimport the data

    Comments (6)
    Ralf Schou-Jensen's profile image Profile Picture

    Niraj on 05 Jul 2020 22:16:57

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    can we publish live connected cubes in the power BI Service as well, to share them with other members in group

    Ralf Schou-Jensen's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:11:18

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    I've connected to SSAS multidimentional and i've seen my cubes, but after i have error
    Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'EntityDataSource'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Errors related to feature availability and configuration: The 'Tabular View' feature is not included in the '64 Bit Standard' edition of Analysis Services.

    Ralf Schou-Jensen's profile image Profile Picture

    pato lobos on 05 Jul 2020 22:11:10

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    Not really for user with no access to the domain. For example I'm outside my network and I need to use PowerBI Desktop to connect live to a tabular model. This scenario resembles "Connecting to SSAS tabular via HTTPS OLAP PUMP"
    Please give me this and the ability to impersonate.

    Ralf Schou-Jensen's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:11:02

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    Awesome..! have been waiting for this for a while. Thank you MS Power BI team

    Ralf Schou-Jensen's profile image Profile Picture

    Michael on 05 Jul 2020 22:09:02

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    Agreed., We spend all of the time creating a cube and then we need to "build another cube""

    Ralf Schou-Jensen's profile image Profile Picture

    Niraj on 05 Jul 2020 22:08:06

    RE: Use Designer to connect live to SSAS Cubes/multidimensional instead of importing the data

    Is there a way even if using a connector to connect Power BI to a multidimensional cube