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
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.

    • Silentbob's avatar
      Silentbob
      Frequent Visitor
      6 years ago

      I have found the answer from a colleague.

       

      When I added the single Optimiser table to Power Bi, Power Bi inferred some relationships with other tables I had previously imported.  Once I manually removed these relationships under the model tab the data displayed.

       

      Just in case anyone else has this issue.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Silentbob，

        Based on your reply, the issue seems to be caused by the table relationships which Power BI auto detect . Thank you for kindly providing this information , it may help others. Thank you.

         

        Best Regards

        Rena