Connecting to Power BI local SSAS instance from SSDT

[wjaniszewski]

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

[bergerlu]

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

[v-yuta-msft]

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]

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