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 akj2784,

 

The Import mode bring all the data into the Desktop file. The intuitive evidence is the size of the pbix file. You still can use it when the connection to SSAS is ended. 

 

When you publish such a file to the Service, you publish all the data in the file. You can check it out in the settings in the Service. 

Dataset_in_Power_BI_Desktop_using_SSAS

 

We can't publish the model back to SSAS. 

 

Please refer to: desktop-directquery-about#import-connections

 

Best Regards,

Dale