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

HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
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.

    • HarrisMalik's avatar
      HarrisMalik
      Icon for Continued Contributor rankContinued Contributor
      10 years ago

      ivan77 With the introduction of Enterprise gatway, which you can install on SSAS server, you will be able to explore live multidimenisonal models. In enterprise Gatway you can also manage multiple servers and sources.

       

      The only limitation at this stage is that from Power BI Service you cannot connect to MD models using get data option. The best way right now is to follow these steps:

       

      1. Install Enterprise Gatway on server and configure it to connect with your MD server

      2. Using Power BI Desktop, create the reports in Live Explore mode

      3. Publish the report to Power BI Service

       

      By following these steps yu will be able to use MD models in live mode on Power BI Service.

       

      Regards

      Harris