
How would it be possible to either customize or create a new report that will generate a list of items purchased by Customers by Item Location. I reviewed the POWER BI Data Sets and don't see LOCATION as an option and I cannot figure out how to export an existing report to *.RDL to add additional fields. For example, I would like either have a Sales Line Items report by Location or a Items by Location by Customer report that will show each Item on an Invoice and where it was purchased from and by who.
Is this possible? Am I missing something on how to export other reports besides those in the Custom Report Layout window?
I think I have the preliminary steps figured out using the Report Layout Selection option and Custom Report Layouts using the help files but it does not look like it is possible to group by Location as I do not see it as an option in the *.RDL file Dataset.
I don't see an option to report Items by Customer By Location that can easily be created.