stored procedure with multiple result sets
I have a Stored procedure that returns multiple result sets, however at the moment when I execute the SP in Power BI I only get the results from the first select statement. It would be better to create a query for each result set returned.
STATUS
DETAILS
Needs Votes
Ʃ Values as Legend or Axis as in Excel
In Excel you have four sections where you can add column data: Ʃ Values, Axis (Category), Legend (Series), and Filter. Into the Legend and Axis sections you can add Ʃ Values. In which case if I have 2 value columns A and B the Axis points would be A and B. Hopefully this makes sense, or you coul...
STATUS
DETAILS
Needs Votes