Forum Discussion

athpl's avatar
athpl
New Member
8 years ago

Sharing data sets in Power BI Report server

Hi,   We have a Power BI Report Server i.e. the on-premise installation. We have few reports which use certain common data. The reports cannot be placed in the same PBIX files due to the business a...
Data set
BhaveshPatel's avatar
BhaveshPatel
Super User
8 years ago

Hi There,

 

If you create a model in SSAS, There are two ways you can connect to that model in Power BI Desktop.

 

1. Import mode

In this mode, You are pulling the data from SSAS Model and importing to your Power BI File. Usually the file size in this case is larger as you are pulling the data from SSAS model. 

 

2. Live Connection

In this mode, You are connecting live to SSAS and the .PBIX files only querying the metadata of the SSAS model so the file size is relatively very small and does not copy any data from SSAS to power BI. It is just the meta data getting stored in the PBIX File.

 

The file size really depends on your connection mode to SSAS.

 

Hope this makes sense!

 

Thanks

Bhavesh

adeshpa4's avatar
adeshpa4
Regular Visitor
8 years ago

Thanks Bhavesh. This is exactly what I was looking for. 

 

Regards

Atul P Deshpande

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    8 years ago

    Hi adeshpa4

     

    Can you please mark this as answer so the thread can be closed.

     

    Thanks

    Bhavesh

    • adeshpa4's avatar
      adeshpa4
      Regular Visitor
      8 years ago

      Gave a thumb-up. Is that what is needed?