I'm new to Power BI. I'm trying to create a report that has detail lines from a stored procedure. I can connect to my data, no problem, I can get the query to work, no problem. The problem is, when I want to design a standard report, I get one total line with NO DETAILS and that's it. I need the detail for this and most of my reports. I also need to get it to group (so that I can send multiple people into the dataset). I see a Row Groups and Column Groups, but I can't drag the group key to it.
Is there any training or information on how to build a standard report (general ledger, list of expenses, purchases, payroll, etc.) without just a summary, but each line listed. I don't need it to collapse nor expand, I just need it to print a heading, column headers, details, totals and of course a page footer with the pages on it.