cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

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

@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.

 

Capture.PNG

View solution in original post

5 REPLIES 5
Highlighted
Community Champion
Community Champion

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

@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.

 

Capture.PNG

View solution in original post

Highlighted
Regular Visitor

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

@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. 

Highlighted
New Member

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

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

Highlighted
New Member

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

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

Highlighted
New Member

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

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.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors