Forum Discussion

ivan77's avatar
ivan77
Regular Visitor
10 years ago
Solved

adding multidimensional data

Hi,   I use the get data>analysis services.  I choose some measures and dimension attributes.  The query adds all of the info into one query.  Doing this puts all of the attributes and measures int...
Need Help
  • HarrisMalik's avatar
    HarrisMalik
    10 years ago

    greggyb From the title of the question it seems he is trying to explore Multidimensional model and not Tabular.

     

    ivan77 Which model you are trying to explore? Multidimensional or Tabular?

    In case you are trying to connect with Multidimensional model, it is still in preview so as greggyb explained you need to enable the preview feature. Secondly, in your earlier comment you mentioned that you are using SQL Server 2012, for live connections to multidimenisonal models you need SQL Server 2012 SP1 CU4 or later with Enterprise or Business Intelligence editions. It won't work on Standard Eidtion.

     

    Please have a look here under Lmitations of SSAS Multidimensional Models in Power BI Desktop.

     

    Regards

     

    Harris

ivan77's avatar
ivan77
Regular Visitor
10 years ago

Also,

 

At 52:08 of this video from MSFT, it looks like he added his whole dimensional model somehow:

 

https://www.youtube.com/watch?v=EBNV7Vuhwb8 

 

should this be like using pivot tables in excel (pick and choose from all measures and dimensions), or should it be query based?

 

Thanks,

 

Ivan

  • greggyb's avatar
    greggyb
    Resident Rockstar
    10 years ago

    Explore the model with a live connection, don't import the data. I believe that live connection with AS MD is still in preview, so you'll have to enable that in your PBI options.

     

    • ivan77's avatar
      ivan77
      Regular Visitor
      10 years ago

      Hi,

       

      My analysis services connection has the "Explore a tabular module using a live connection" greyed out.  

       

      I am using SQL 2012.  Any ideas why that would be the case?

       

      Thanks,

       

      Ivan

      • greggyb's avatar
        greggyb
        Resident Rockstar
        10 years ago

        What's wrong is that you haven't enabled the preview feature to allow live exploration of an AS MD model. The option you have described clearly states it is for a Tabular model.

         

        Please enable the preview feature.