Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Dataset in Power BI Desktop using SSAS

Hi All,   I am using SQL Server Analysis Services to create data model in Power BI Desktop using import method. I assume the data is in memory in SSAS.  Just wanted to check what happens to data ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Akash,

 

As far as I know, we can't deploy the PBI model to SSAS directly. The SSAS is also a powerful analysis tool. Why not using Direct query in Power BI? Most of work will be done in the SSAS database.

 

Best Regards,

Dale

akj2784's avatar
akj2784
Post Partisan
8 years ago

Hi Dale,

 

I am trying to follow the below blog which has the steps to import the power bi model to SSAS. The only difference is I have SSAS 2017.

 

http://biinsight.com/import-power-bi-desktop-model-ssas-tabular-2016/

 

Also, whatever model I have already created using Oracle db, I don't want to waste that effort. So I am trying to deploy the already built model in SSAS.

Also,

with Live connection, when I try to connect to SSAS from Power BI Desktop, it doesnt give me flexiblity to model the tables in Power BI Desktop. It expects the model to be already built and deployed to SSAS.

Correct me if I am wrong.

 

Really appreciate your reply.

 

Regards,

Akash