Shared PBIX Data Source

[Jarrod]

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.

[Jarrod]

That's a shame. Thanks Greg.

[Greg_Deckler]

@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.

[Jarrod]

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.

[Greg_Deckler · Accepted solution]

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