Forum Discussion

Lachel_A's avatar
Lachel_A
New Member
4 years ago

Visua not displaying all data from database

I have a dashboard that i refresh daily and loads data from SQL database. I realised few days ago that visuals are not picking all the data from the database no matter how many times I refresh. I also did not change anything in the queries or measures.

Please can anybody help with this, it is very critical to our business.

Thank you.

Data Protection

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Lachel_A , check if the incremental refresh is successful. (Under dataset setting -> refresh history)

    Check incremental settings are correct

     

    Clear browser cache refresh and check

     

    or switch of Query cache at dataset level and check

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Lachel_A , 

     

    Please make sure that there are no filters in the refresh process.

    1. no filters in measure if you created
    2. no filters on this visual
    3. no filters during query statement(m query) 

    Best Regards

    Community Support Team _ chenwu zhu

     

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