Forum Discussion

Aniruddh's avatar
Aniruddh
Regular Visitor
9 years ago

Unable to access SSAS tabular cube on pwerbi Service.

HI Guys, I have created a tabular ssas cube on my sql server 2016 developer edition using ssdt.  I have connected my powerbi desktop with this cube using 'Connect Live' option.  After creating a f...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Aniruddh,

 

There is a limitation to use a live connection against tabular or multidimensional instances. See: Limitations of Analysis Services live connections.

 

  • 2012 SP1 CU4 or later (Business Intelligence and Enterprise SKU)
  • 2014 (Business Intelligence and Enterprise SKU)
  • 2016 (Standard SKU or higher)

Please check if the server version and required SKU meet the requirement firstly.

 

Also please check if you need to create a rule to match Power BI service login names with your local directory UPN. See: Usernames with Analysis Services.

 

Best Regards,
Qiuyun Yu

 

 

  • Aniruddh's avatar
    Aniruddh
    Regular Visitor
    9 years ago

    I am using developer edition. I believe that should not be an issue. Or is it?

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      Hi Aniruddh,

       

      I have to say that the Developer Edition of SQL Server is not currently supported for Live connections to Analysis Services.

       

      Best Regards,
      Qiuyun Yu

      • Aniruddh's avatar
        Aniruddh
        Regular Visitor
        9 years ago

        What about Evaluation edition? Need to know before i install it.

         

        Regards

        Aniruddh