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