Hey all, new to the Business Central platform and Power BI reporting. My company has just gone live with Business Central for finance, inventory, and warehousing and its a pretty simple setup. The issue is that the native reports in BC are lacking what they are looking for and I'm trying to figure out the best way to modify the data sets and layouts to give them what they need. I've read quite a few posts and articles but it looks like they might be outdated at this point, so I'm turning to the community to help point me in the right direction.
Specifically, one report I'm looking at right now is the Customer Sales Statistics. I was able to download the layout files for it, but I'm struggling to find the .al file to see if I can expand on the data its gathering and presenting. The report currently shows the first couple months of sales by customer, then has a single column at the end that basically says "and beyond", where they need all 12 months of sales in separate columns.
1. Is downloading the docker container and running the on-prem version still the best/only way to get everything I need to start modyifying reports?
2. Is there a repository some where of customized reports that people have put together, something I can grab and customize?
3. Editing in VS Code or Power BI Report Builder the best way to work through this?
Appreciate any help you can offer!