Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Jarrod Sorry, missed that this was in the Report Server forum. No, one of the many limitations of Report Server.
That's a shame. Thanks Greg.
@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.
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.
@Jarrod Sorry, missed that this was in the Report Server forum. No, one of the many limitations of Report Server.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |