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

Thanks for the info.  

 

After reading though the documentation, I realize this will not work, as I am actually trying to create a dashboard for company use now.  It states that the link HarrisMalik sent:

 

In this preview release, SSAS Multidimensional models in Explore Live mode are only supported in Power BI Desktop, and you cannot publish or upload reports that use SSAS Multidimensional models in Explore Live mode to the Power BI service.

 

So, I guess I have to create a query for each individual visual after all.  

 

Thanks,

 

Ivan

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

You don't have to write separate queries for each visual, and in fact this would absolutely destroy most of the interactive features in Power BI.

 

You should bring over the fact tables and dimension tables as they exist in MD, preserving the relationships (Power Query can do this automatically when you browse the cube for data to import), so that you can report on the same dimensional model.

 

Also, keep an eye on the Enterprise Gateway, which is currently in preview. It is the piece that will allow direct query against AS MD models from the PBI Service.