Forum Discussion

Revanth's avatar
Revanth
New Member
5 years ago

Data not updating properly in Table Visualization

Hi,

I have connected a SQL server with direct query. I have created a three visualization (Table, Pie Chart and Card).

Table data has not been updated properly with some filters alone, but it was updated in Pie chart and Card. Please See Example below,

 

Example :

Filter - Date , Position, Status

Card Visualization - 4 (Total records)

Pie Chart (Legend) - Accepted (3), Rejected (1).

Table Visualization - It only shows 2 records, but it supposed to be show 4 records. (But in some filters, it was shown properly)

 

Note : I have used only single table. All fields are in the same table only.

 

Any idea on this issue.

 

Thank you for your help!

 

Regards,

Revanth

Need Help

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi Revanth ,

     

    If other visual charts can be displayed correctly, then the connection and refresh between Power BI Desktop and the data source are normal. It may be a problem with your filtering conditions and data model. It is best to provide an example .pbix file (import mode is ok).

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.