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
mgmeyer's avatar
mgmeyer
Power BI Team
8 years ago

Unfortunately there is no way right now to share an embedded model that is in a PBIX report; however you can create a common model and deploy it to an Analysis Server which report authors can use, it would achieve the same thing.

adeshpa4's avatar
adeshpa4
Regular Visitor
8 years ago

Thanks for the response. Even if I create a model in SSAS, Power BI will still make a copy of the data in PBIX file. Now, if I have a large data, and multiple reports using that data,  I shall have multiple such PBIX files, which will consuming the memory. Is there a way out?

  • 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

  • biggerpez's avatar
    biggerpez
    Frequent Visitor
    8 years ago

    If it is just one table of data (SSRS), you can direct query the data rather than import or using SSAS.