Sharing data sets in Power BI Report server

[athpl]

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 area seperation. Power BI stores the data in the PBIX file. Is there a way, that, the common data can be shared across PBIX files. It unnecessarily keep the common data and utilizes the RAM. Any suggestions or workaround is welcome.

Regards

Atul

[mgmeyer]

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]

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?

[biggerpez]

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

[BhaveshPatel]

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]

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

Regards

Atul P Deshpande

[BhaveshPatel]

Hi @adeshpa4

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

Thanks

Bhavesh

[adeshpa4]

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