Need help on query editor issue as its not showing errors

Hi sankeytmehta ,

I am asking again, can you share your power bi file?

Also you have only one Power BI Desktop application on your machine right? YOu installed this on your machine from Microsoft Store right?

Thanks,

Pragati

HI sankeytmehta ,

I opened your POwer BI file and I see the options at my end. See below:

There is definitely something wrong at your end.

Thanks,

Pragati

Hi sankeytmehta ,

Hard to judge the issue as your file works perfectly fine at my end, shows everything.

Do one thing. Uninstall any power Bi desktop installation you have. Restart machine. Then install again from the microsoft store.

Thanks,

Pragati

I am using desktop only and not server. Also I'm using the latest version only. 

The PBIX file and dataset - File and dataset 

The exe file uploaded in case anyone wants to install on their machine and see if they are getting same issue. PBIDesktop64 exe file 

Will delete the exe file once issue is resolved.

Yes single instance of power bi and that too downloaded from Microsoft website https://powerbi.microsoft.com/en-us/downloads/

Thanks for all the help. Yes definitely the issue is at my end but don't know what and why??

Did that multiple times but still the same 🙄

Will it be possible for you to share the exe file you're using? Thanks in advance!

But will I get any help from BI support?

Recently, I faced the same issue i.e., the "power query editor is not showing errors". I found the problem with me is that I am using an "old" version of Microsoft (i.e., version 19).  Anyone with the recent version can follow the steps below to resolve the issue: 1) go to the View tab on the ribbon, and 2) enable the Column quality in the Data preview group. I think they are part of the PQ Data Profiling Tools. Here is the link to the reference material Using the data profiling tools - Power Query | Microsoft Docs