Forum Discussion
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!
HI sankeytmehta ,
Not sure then.
Please close the thread and mark a solution as this is someting happenieng at your end.
Thanks,
Pragati
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
Solution 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 - Pragati11
Super User
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
- sankeytmehta
Helper II
Hi,
Why I am not able to see the column profile in query editor any idea? Can some one share the path of exe file used to download the powerBI. I had downloaded and installed powerbi 2 times from here
https://www.microsoft.com/en-us/download/details.aspx?id=58494
My query editor is not showing these options - Query editor
Thanks!
- v-lili6-msft
Community Support
hi sankeytmehta
From this screenshot, it is old version in power bi, please check what is your version for this power bi desktop
and we also download the power bi desktop in here:
https://www.microsoft.com/en-us/download/details.aspx?id=58494
please uninstall the version and download and install again.
Regards,
Lin