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.

  • Silentbob's avatar
    Silentbob
    Frequent Visitor
    6 years ago

    Hi The table idea didnt work either, see below.  Its weird!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Silentbob ，

      First, please check if there is any slicer or filter applied for report affected the data displaying onto visual. If applied any RLS? Could you please provide the data information on table " Optimiser " under " Data " tab in Power BI Desktop ?

       

      Or you have the similar scenario with this one: https://www.sqlbi.com/articles/understanding-dax-auto-exist/

       

      Best Regards

      Rena

      • Silentbob's avatar
        Silentbob
        Frequent Visitor
        6 years ago

        Hi Anonymous 

         

        Here is the screenshot you requested.  There is no filtering or RLS as its a new datasource.

         

         

        I will read your link after I post this reply and feedback.  Its wierd as it is an incredibly simple SQL table and I want to display it as is.