topic Re: Sharing data sets in Power BI Report server in Report Server

Sharing data sets in Power BI Report server

athpl — Wed, 22 Aug 2018 12:38:00 GMT

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

Re: Sharing data sets in Power BI Report server

mgmeyer — Thu, 23 Aug 2018 20:56:27 GMT

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.

Re: Sharing data sets in Power BI Report server

adeshpa4 — Fri, 24 Aug 2018 05:14:09 GMT

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?

Re: Sharing data sets in Power BI Report server

BhaveshPatel — Fri, 24 Aug 2018 06:32:16 GMT

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

Re: Sharing data sets in Power BI Report server

adeshpa4 — Fri, 24 Aug 2018 06:41:36 GMT

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

Regards

Atul P Deshpande

Re: Sharing data sets in Power BI Report server

BhaveshPatel — Fri, 24 Aug 2018 06:44:40 GMT

Hi adeshpa4

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

Thanks

Bhavesh

Re: Sharing data sets in Power BI Report server

adeshpa4 — Fri, 24 Aug 2018 06:50:37 GMT

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

Re: Sharing data sets in Power BI Report server

biggerpez — Fri, 24 Aug 2018 08:16:36 GMT

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