Forum Discussion

sankeytmehta's avatar
sankeytmehta
Icon for Helper II rankHelper II
6 years ago
Solved

Need help on query editor issue as its not showing errors

I have downloaded latest version of Power BI. I loaded data from csv files to query editor. One of the file has empty rows. So as per query editor documentation and the udemy tutorial, query editor shows green/red bar in between data rows and header. But in my system i am not seeing that green bar.

 

As per document - Document (marked with black arrows)

 

In My system - My system (marked with black arrows)

 

Also, as per udemy tutorial, when we hover the mouse over the columns it shows a information box. In that box we can see the stats like valid % error %, empty % and remove empty row. But I am not seeing that as well in my system.

Tutorial - Tutorial 

 

Need help on both the issues. Or pointer to any document, link, settings. Any help will be really appreciated!!

 

Thanks in advance!

 

 

  • Pragati11's avatar
    Pragati11
    6 years ago

    HI sankeytmehta ,

     

    Not sure then.

    Please close the thread and mark a solution as this is someting happenieng at your end.

     

    Thanks,

    Pragati

  • sankeytmehta's avatar
    sankeytmehta
    6 years ago

    My OS version was older, due to which i was not able to see the column quality,  distribution, profile options, error indicator - green/red. I did system format and then loaded windows 10. After that installed Power BI desktop again from Microsoft website. Now the issue is resolved.

     

     

    Thanks!

24 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage

    Hi,

    You can check "Column profile" in the "View" section of Query editor.

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

     

  • Hi sankeytmehta ,

     

    Regarding the GREEN bar issue, not sure why that's happening at your end. I have got JULY 2020 Power BI update and see it at my end:

     

    For the second issue go to Query Editor --> View and do as shown below to view column stats:

     

    Thanks,

    Pragati