Don't have "Remove Errors" option in my Power BI desktop

[parvaneh]

Hi, I am watching Lynda.com videos on Power BI Desktop and the tutor is using "Remove Errors" and "Remove Duplicates" options, but I don't have these two options. Is it because they only exist in Power Bi Desktop Pro? 

[ankitpatira · Accepted solution]

@parvaneh there is no Pro or trial version for desktop. In power bi desktop you need to click on Edit Queries, then select your query and under Home tab under Remove rows click on dropdown and you should get those options.

[duncsindevon]

Or if you only have Power BI use the right mouse key/button when selecting the colums with errors ane the optin is available.  Not obvious from Lynda.com as she is working in Power BI Pro Desktop.

[duncsindevon]

Not available in Power BI Desktop only avaialbe in the Pro Version.

[duncsindevon]

REmove Errors and not reomve columns.  Remove Errors and Remove Duplicates only avaialble in the Pro version!

[parvaneh]

@ankitpatira Thank you. Actually I am watching Lynda videos on Power Bi and the lady mentioned that we have Power BI desktop and desktop pro.