Forum Discussion

Silentbob's avatar
Silentbob
Frequent Visitor
6 years ago

Issue displaying SQL table data

Hi,   I am creating a dashboard and I have numerous graphs based on SQL data and all work fine.   I want to add a control that displays text data from another table.  The data is as follows in SQ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I maybe on the wrong track here but I think the key using the Matrix visual. This visual requires a value - you will note that the value Power BI selects is 'First - LoggedBy' - this means it returns the value in the first row of that column. That may well be a blank!

 

If you use a Table visual and ensure that the columns in the Values section are set to "Don't summarize" then you should be able to see all the values. Make sure that the ID column is included because the Table visual will 'summarize' for matching values (if memory serves me right) and therefore you won't see all the values unless you include the ID column.

Silentbob's avatar
Silentbob
Frequent Visitor
6 years ago

I will try what you suggest in your second column.

 

In regards to your comment on the matrix, as I am testing currently there are no blank rows in the SQL table there is only 1.