The default Power BI dataset that ships with Concourse is limiting, susceptible to connection errors, and cannot be optimized due to the privacy of the database connection credentials. Being able to create custom datasets from a Concourse datamart or dataflow would be extremely helpful for client reports.
Thank you for the idea, Kyle! I've assigned this to our team that focuses on reporting, thanks again!