topic Re: Shared PBIX Data Source in Report Server

Shared PBIX Data Source

Jarrod — Sun, 04 Sep 2022 07:56:20 GMT

Hi All,

Am I able to publish a blank pbix with no visuals and just several queries with many other PBIX reports utilising this as a data source?

This would save SQL Server resources as the data set (blank pbix) would just need to be refreshed once rather than the queries refreshed for each report.

Re: Shared PBIX Data Source

Greg_Deckler — Sun, 04 Sep 2022 16:13:50 GMT

Jarrod Correct. You can use Live mode connection to that dataset or DirectQuery for Power BI and Analysis Services. That is actually a recommended approach for enterprise BI scenarios and is covered in depth in Mastering Power BI 2nd Edition.

Re: Shared PBIX Data Source

Jarrod — Sun, 04 Sep 2022 20:27:06 GMT

Thanks Greg_Deckler - Is this available in report server? This link shows Power BI dataset in report server as not available for live/direct query.

Re: Shared PBIX Data Source

Greg_Deckler — Sun, 04 Sep 2022 20:31:28 GMT

Jarrod Sorry, missed that this was in the Report Server forum. No, one of the many limitations of Report Server.

Re: Shared PBIX Data Source

Jarrod — Sun, 04 Sep 2022 21:05:57 GMT

That's a shame. Thanks Greg.