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 when we publish this model to Service. 

 

Can we publish the model back to SSAS so that the data doesnt go to cloud and when we access the dashboard from Service, the gets from SSAS in memory ?

 

Regards,

Akash

Need Help

7 Replies

  • 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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi akj2784,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale

    • akj2784's avatar
      akj2784
      Post Partisan
      8 years ago

      So basically when we import the tables from SSAS in Power BI Dekstop, it imports all the data to the file and when I publish it to the service the data also goes to cloud along with file and hence when I run the report, the data gets pulled from the cloud but not from in memory SSAS database and hence in this scenario we are not leveraging the in memory SSAS database.

       

      Is this correct understanding as per your reply ?

       

      Thank you for the the reply.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi akj2784,

         

        Totally right. In my opinion, the biggest advantage of Import mode is performance. We don't need to consider the bad bandwidth and the workload of the SSAS server. 

        There are many solid evidences we can see the Import mode is working alone.

        1. If we shutdown the SSAS server or close the network connection, the reports work fine.

        2. The size of the pbix file (Power BI Desktop file).

        3. We can use that file in a environment where we don't have access to the SSAS Server.

         

        Dataset_in_Power_BI_Desktop_using_SSAS2

         

         

        Best Regards,

        Dale