Forum Discussion

crlll's avatar
crlll
Frequent Visitor
6 years ago
Solved

Data in Query Editor and Table View, but not in the report

Hello Team,

I hope you stay safe. I have a problem with my data that I would like a little help with. Note that I'm new to PowerBI and I'm building on an existing dataset that may have resulted in a step missing.


I recently updated my queries for two tables to include an additional column of two different tables in our SQL database. After applying the query changes, I can see that the data was extracted until yesterday in both Query Editor and Table View (when I ran this, 4/30/2020). Then I went to the Reports section and updated the Report, but I was unsuccessful.

To use a single visual as an example, dates jump from 6/29/2019 to 5/1/2020, missing everything else. I have confirmed that there are dates between these two data points in the query editor.

Could you get me out in the right direction?

Thank you

Crlll

  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi crlll ,

     

    According to your problem, you could create a table visual and put a single date column into it. Check if it work properly, maybe you have some page filters. And you may accidentally selected the data on other visuals, please check it.

     

3 Replies

  • sanimesa's avatar
    sanimesa
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Could you please some screenshots of this issue? It is a little hard to visualize what you are seeing. 

    Also please make sure your refresh is successful and confirm by using a measure like countrows etc. 

     

    Thanks.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      crlll do you have any filters?  Are you using any measure? Maybe there is data type issue and some relationships are broken? Can you just drop a simple table visual and check.

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi crlll ,

     

    According to your problem, you could create a table visual and put a single date column into it. Check if it work properly, maybe you have some page filters. And you may accidentally selected the data on other visuals, please check it.