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

    b2236b8e 66aa-4066-b956-93b9251a9aa7 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

    178b028d 2f72-441b-ba42-829e2b06a23f 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

    1fb02eeb 04bc-46f6-95c1-18197463356f 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

    fc610530 ed1e-4b36-a075-51c83abd347c 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

    c67d8165 36bd-4861-8e47-268ba31dfb94 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

    b2236b8e 66aa-4066-b956-93b9251a9aa7 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