Forum Discussion

wjaniszewski's avatar
wjaniszewski
Frequent Visitor
8 years ago

Connecting to Power BI local SSAS instance from SSDT

Hi Guys,

 

I was wondering whether it's possible to connect to Power BI local SSAS instance from SSDT... I can certainly do it from Excel or SSMS but when I try to import Tabular model in SSDT using 'localhost:portNumber' I do get errors like "Tabular instance not runinng in VertiPaq mode". 

I want to do it to persist my PowerBI tabular model... idea was to import it into Tabular solution and then deploy it onto a named Tabular instance and make it a reusable data model. 

 

I know you can achieve this by using PowerBI service and Azure Analysis Service but is this also possible on prem??

 

Many Thanks,

 

Wojciech

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi wjaniszewski,

     

    Please check if you have installed multiple instances on your database server. "localhost" should be changed by ServerName/InstanceName.

     

    In addtion, you said "I want to do it to persist my PowerBI tabular model... idea was to import it into Tabular solution and then deploy it onto a named Tabular instance and make it a reusable data model. "

     

    <---Could you clarify more details about your requirement?

     

    Regards,

    Jimmy Tao

    • wjaniszewski's avatar
      wjaniszewski
      Frequent Visitor
      8 years ago

      Hey Jimmy,

       

      Thanks for coming back to me.

       

      I don't try to connect to a named instance (ServerName/InstanceName). PowerBI desktop does spin up a temporary SSAS instance when it gets open under localhost:XXXXX where XXXXX is a dynamically allocated port and Tabular database name would be something like "947a362d-1e9b-413b-9da8-1a4ba08de955". I can connect to it from PowerPivot and SSMS but not from SSDT.

       

      I would like to import this database into Tabular solution hence I want to connect to it from SSDT. Once I have it as Tabular solution I could deploy it to a named Tabular instance (ServerName/InstanceName) and have it reusable/shared across different PowerBI apps (connecting via live connection in PowerBI desktop). 

       

      I hope that makes sense.

       

      Wojciech 

  • bergerlu's avatar
    bergerlu
    Icon for Helper I rankHelper I
    7 years ago

    Did you find an answer for this ? I'm also wondering if we can deploy a tabular model from SSDT to the local powerbi SSAS instance