Sharing data sets in Power BI Report server

Question

Hi,&nbsp;We have a Power BI Report Server i.e. the on-premise installation. We have few reports which use certain common data. The&nbsp;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.&nbsp;RegardsAtul

bhaveshpatel · Answer

Hi There,&nbsp;If you create a model in SSAS, There are two ways you can connect to that model in Power BI Desktop.&nbsp;1. Import modeIn 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.&nbsp;&nbsp;2. Live ConnectionIn 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.&nbsp;The file size really depends on your connection mode to SSAS.&nbsp;Hope this makes sense!&nbsp;ThanksBhavesh

mgmeyer · Answer

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 · Answer

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,&nbsp; I shall have multiple such PBIX files, which will consuming the memory. Is there a way out?

adeshpa4 · Answer

Thanks Bhavesh. This is exactly what I was looking for.&nbsp;&nbsp;RegardsAtul P Deshpande

bhaveshpatel · Answer

Hi&nbsp;adeshpa4&nbsp;Can you please mark this as answer so the thread can be closed.&nbsp;ThanksBhavesh

Forum Discussion

Sharing data sets in Power BI Report server

7 Replies

Related content

Report Sharing

Sharepoint online and Reporting server

Power BI Report Server migration to new servers

PBI Report Server Schedule refresh

Report sharing strategy